D
Djembe
I need to produce a chart which has a scale of equally spaced lines on
the y axis. But the values (real values) of those lines are not
uniform. For example, the scale reads 10,25,32,37,41,45,50 but they
are all equally spaced visually on the chart. I then need to plot
historic values (say for 3 years) against that scale - effectively
plotting an interpolated point between them.
How can Excel do this?
Many thanks in advance.
the y axis. But the values (real values) of those lines are not
uniform. For example, the scale reads 10,25,32,37,41,45,50 but they
are all equally spaced visually on the chart. I then need to plot
historic values (say for 3 years) against that scale - effectively
plotting an interpolated point between them.
How can Excel do this?
Many thanks in advance.