Reversing chart
 

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
--
http://www.dbconsult.dk
http://www.vinthervej2.dk [private]

Reversing chart
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Morten Snedker" <morten_spammenot_ATdbconsult.dk wrote in message
...
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
--
http://www.dbconsult.dk
http://www.vinthervej2.dk [private]