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

Yeah, I guess that's a solution but since we spend most of our time on the right-hand side of the pivot chart looking at the most current data I just set the Axis Labels to "High".

Thanks for the reply

Chris