dual scale for charting

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

On Tue, 21 Oct 2003 13:02:35 -0700, Dennis Mannon =

wrote:

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

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/...mmySeries.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.

-- =

Dave
dvt at psu dot edu

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Dennis Mannon wrote:

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