Reversing chart

  • Thread starter Thread starter Morten Snedker
  • Start date Start date
M

Morten Snedker

http://www.dbconsult.dk/ms/diagram.jpg shows a diagram and its data.

The A-columnt holds the months for the label at x-axis. (5th month and
6 months backward). The D-column (g/kWh) holds the actual data for the
diagram. This part is fine.

However, it is more intuitive to have the oldest month shown first
(most left) in the diagram. So that the diagram from left to right
shows the months 12 to 5, showing past to present.

Is it possible to have the data shown as they are, but have the chart
to reverse the months?


Regards /Snedker
 
Hi,

Double click the x-axis and on the scale tab of the Format Axis dialog check
both
Categories in Reverse Order
Value (Y) axis crosses at maximum category

Cheers
Andy
 
Back
Top