how to: Mirror Y axis on both sides of chart

Posted by Dave on August 09, 2000 8:42 AM

I have automated a large process that produces many charts in Excel 97 under Windows 98.

I would like the Y axis labels repeated on the right side of the chart, too.

Posted by judi on August 09, 0100 10:13 AM

One easy way is to create a second set of series using the same values as the first.
Then you format the second Data Series and select the Axis tab and choose Secondary.

HTH