A
a.t.brooks
Hi Guys,
I posted this a week ago, but it seems to have vanished from the
board!
Is it possible to plot two data sets on the same line graph with
different scales? i.e. Have a secondary axis, like in Excel?
I have one dataset fluctuating around 2.0 over time and another
dataset fluctuating around 50 over time.
If I plot both of these in the same graph, I lose the subtle changes
in the first dataset.
I can sort of bodge it by writing a query with an expression to
multiply the first dataset by 25, but then I can't get the "real"
values to show on the axis.
I find the graph function in Access very infuriating. Why can't they
just allow yout the same features as in Excel?
Thanks for your help (if anyone can solve this one)
Tony
I posted this a week ago, but it seems to have vanished from the
board!
Is it possible to plot two data sets on the same line graph with
different scales? i.e. Have a secondary axis, like in Excel?
I have one dataset fluctuating around 2.0 over time and another
dataset fluctuating around 50 over time.
If I plot both of these in the same graph, I lose the subtle changes
in the first dataset.
I can sort of bodge it by writing a query with an expression to
multiply the first dataset by 25, but then I can't get the "real"
values to show on the axis.
I find the graph function in Access very infuriating. Why can't they
just allow yout the same features as in Excel?
Thanks for your help (if anyone can solve this one)
Tony