[Drahos]

Hello,

I need to create a chart with two y axis.
First y axis ranges from 10 to 100 and second one from 100 to 1000.
X axis values ranges from 1 to 12 for both y axis.

Is it possible to create such a chart in MS Excel?

Thanks for your help
DJ

[MikeTheBike]

Hi

From Excel help

When the range of values for different data series varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.To plot a data series along a secondary axis, click the series, and then click Data Series on the Format menu. Click the Axis tab, and then click Secondary axis.

(From Excel97)

HTH

MTB