one data series - two axis

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

i am trying to create a graph that tracks price/metric ton
over time. on a second y axis i would like to have the
equivalent price per lb. i only want to see one line on
the graph, but whenever i try to do this, i come up with
two lines. any ideas? thanks, matt
 
Matt -

You need at least one series per set of axes. But the second series can
be formatted so it is invisible (no markers and lines, or no border and
no fill).

- Jon
 
Matt,
since Dave points out that the ratio is 2204.62 I guess that rounding this
to 2200 would not show a marked difference on a graph.
Then select your ranges so that the price per ton is a multiple of 11. I
have no idea about the prices but as an ..
Example
Axis price per lb form 2.3 to 6.4, change to 2 to 7, ticks at .2, Horizontal
lines at 3, 4, 5, 6
Choose for a range for the ton, 4400 to 15400, ticks at 200, Horizontal
lines above will reach the other axis at 6600, 8800, 11000, 13200.
These are not perfectly round numbers, but is is easier to interpolate with
yr eyes between values of 100 than through 12378;31 and 2356;78
HTH,
Pierre
the only problem I have is the lines do not match up
exactly - it skews the graph...
Click to expand...

$/metric ton converts to $/lb by a factor of 2204.62.... If you are
trying to use "nice" limits (i.e. 0,10,20,...) on both scales, they will
never line up.

I suggest you create an arbitrary axis for one of your axes. The
procedure for doing so is shown on
http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#ArbAxis.
 
Back
Top