How to display 2 scales on left and right?

[Eric]

Does anyone have any suggestions on how to display 2 different scales on left
and right? For example, I get data under 3 column
Date data1 data2
... .. ..

I would like to show the range for data1 on left and data2 on right.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Mike Middleton]

Eric -

In general, if you have two or more data series, you can select a data
series and choose to display the data series on a secondary axis.

For more specific instructions, please specify the version of Excel, e.g.,
2003 SP3 or 2007 SP2.

- Mike
http://www.MikeMiddleton.com



Does anyone have any suggestions on how to display 2 different scales on
left
and right? For example, I get data under 3 column
Date data1 data2
... .. ..

I would like to show the range for data1 on left and data2 on right.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric