reversing the axis on a chart

  • Thread starter Thread starter Chris Strug
  • Start date Start date
C

Chris Strug

Hi,

I have a pivotchart based on some financial data. From that I have created a
pivottable/chart. However as the data is financial, the +/- values re
reverse to what I would expect (i.e. top 10 becomes bottom 10, etc) and as
such when plotting a simple bar chart, the chart appears to be upside down
as all the figures being plotted are negative.

Is there a way to invert the axis so that the chart appears "normal" without
changing the original data? I've tried playing with the axis options with no
success.

Any and all advice is gratefully received.

Kind regards

Chris.
 
Chris Strug said:
Hi,

I have a pivotchart based on some financial data. From that I have created a
pivottable/chart. However as the data is financial, the +/- values re
reverse to what I would expect (i.e. top 10 becomes bottom 10, etc) and as
such when plotting a simple bar chart, the chart appears to be upside down
as all the figures being plotted are negative.

Is there a way to invert the axis so that the chart appears "normal" without
changing the original data? I've tried playing with the axis options with no
success.
Click to expand...

Format Axis/ Scale/ select "Values in reverse order"
should do it.
 
Back
Top