dual scale for charting

  • Thread starter Thread starter Dennis Mannon
  • Start date Start date
D

Dennis Mannon

I am looking to create some charts in excel to demonstrate
product performance. The charts will be used by persons
who are familar with the Imperial system. (gallons per
minute) and some persons in other companies will be using
the metric equivalent (liters per minute)

My question is there a way to show both in the scale
columns of the chart?

In the past we have added text boxes on top of the chart
but every opening of the chart required the next be
repositioned.

Please advise
 
I am looking to create some charts in excel to demonstrate
product performance. The charts will be used by persons
who are familar with the Imperial system. (gallons per
minute) and some persons in other companies will be using
the metric equivalent (liters per minute)

My question is there a way to show both in the scale
columns of the chart?

In the past we have added text boxes on top of the chart
but every opening of the chart required the next be
repositioned.

Please advise
Click to expand...

You can plot a series against a secondary axis that is calibrated to a
different scale. I'd suggest creating a dummy series (one that is
formatted to be invisible - see
http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html).
Select that series (preferably *before* you make it invisible) and go to
Format | Selected data series | Axis tab. Select the secondary axis.

Now you can change the scaling of the secondary axis to show imperial
units while your primary axis is scaled to metric units, for example.
 
Dennis -

As an alternative to Dave's suggestion, if you like the text box
approach, try using data labels instead. Put the desired labels into a
worksheet range. Download & install Rob Bovey's Chart Labeler, a free
Excel addin (http://appspro.com), and apply this range as data labels
either to your plotted data, or if necessary to an invisible dummy series.

- Jon
 
Back
Top