Excel Charts and Data

[Alec]

This is my data:

Jan 23
Feb 25
March 31
April 22
May 29
June 45

I need to construct a chart that reads from left to
right, not from right
to left as it does by default. How can I do that?

Excel does it from right to left so my June data is on
the right.

Thanks

 

[Bernard V Liengme]

Put the values in the other way round?
Bernard

 

[Andy Pope]

Hi Alec,

Select the category (X) axis and right click.
Pick format axis.
On the Scale tab check the two options
Categories in reverse Order
Value (Y) axis crosses at maximum category.

This should make the months go Jun to Jan

This is my data:

Jan 23
Feb 25
March 31
April 22
May 29
June 45

I need to construct a chart that reads from left to
right, not from right
to left as it does by default. How can I do that?

Excel does it from right to left so my June data is on
the right.

Thanks

--

Cheers
Andy

http://www.andypope.info