Show Y Axis on both ends of a chart

Is there an effective method to show the Y (vertical) axis on the left and right side of a chart simultaneously?

Thank you for any assistance.

Sincerely,

mksnyder

Hi,

Click the chart wizard, Custom types, Line - column on 2 axes should do the trick

ok, we're using Excel 2007, and the chart is already built...

Thank you.

This worked:

• Right click on one of the dataset lines in the chart
• It should get some sizing blocks on it, then select Change Series Chart Type
• When the dialog box opens, change to a regular bar chart (top leftmost selection)
• Click OK
• Right click on the new dataset (on one of the bars), select Format Data Series
• One of the selections on the left should be Series Options, and one of the options in that group should be ‘Plot Series On’…and Primary Axis should be selected
• Choose Secondary Axis
• It should duplicate the ‘Y’ axis on the opposite side from where you have it set.
• Don’t panic about the formatting, it’s pretty easy to format it after the fact.
• Then you just reverse the process to set the chart type back.

Thanks much, this is a great resource...

mksnyder

Hi,

When I answered earlier I was using 2003, I'm now home and on 2007 and can see what you are doing now. That's a good result!