I have a very wide pivotchart in Excel 2010 and I'd like to display the same y-axis labels on both ends of the chart.  I've experimented with Format Axis | Axis Options | Axis labels and I've learned that "High" will move the labels to the right-hand side of the pivotchart.  Ideally there'd be a "high and low" option, but there's not.  How can I display the same y-axis labels on both ends of the pivotchart?

Christian Bahnsen

• Edited by Christian.Bahnsen Thursday, August 27, 2015 1:49 PM

Hi Christian Bahnsen,

Did you want to get the result as shown in the following figure:

Add an duplicate set of data to the chart. This can be done by either:

• Select the range of data and then drag & drop the data onto the chart
• From the chart menu use Add Data, and select the range of data
• Use the Source data dialog to add a series and then select the range of data

I suggest you refer to this link about "Displaying Y axis values on both sides of plot area":
http://www.andypope.info/tips/tip005.htm

If your requirement is different, I suggest you provide more information.

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su