If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
dual scale for charting
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 |
#3
|
|||
|
|||
dual scale for charting
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 |
Thread Tools | |
Display Modes | |
|
|