Reversing chart

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to chart months by financial year 0
Excel 2007 is charting skinny lines instead of columns 9
Set position of x axis labels 2
How to Plot This Data? 2
Reversing Dates Sequence along X axis in a chart 3
Chart Displays in reverse order 1
Bar chart by month 1
Chart with columns and lines 1

Top