MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chart question

Posted by Dee on October 28, 2001 9:41 AM

Is there a way to show the y axis legend on both the right & left of a chart?

Posted by Jonathan on October 28, 2001 2:34 PM

This works: Make your chart (I'll assume that it's a simple 1-series chart, say a bar chart of Names across the X-axis and scores along the Y-axis). After the chart is made, right click somewhere in the chart and pick Source Data. Pick the Series Tab. Highlight Series1 and Copy what is in the Values textbox (or just make a note of where the values are coming from, the range that's designated in the Values textbox). Now click Add and make the Values for the added Series2 be the same as they were for Series1. Click OK. Now your chart has a pair of bars for every value. They are two different colors and one is the one you just added. Right click on the one you just added and choose Format Data Series. In the dialog box choose the Axis tab and click the radio button that says Secondary Axis. Click OK. I don't really know why there's only one bar for each value again - perhaps the two bars are overlapping now? - but there is only one visible (what we want) and there is a Y-axis at both the left and right ends of the chart. If you want to change the color of the bars right click them again, choose the Patterns tab, and make any adjustments you want.


Posted by Dee on October 29, 2001 5:02 AM

Worked like a charm even tho I use a line chart. Thank you!

Posted by Jonathan on October 29, 2001 7:03 AM

Happy to help :)