Excel Charts and Data

  • Thread starter Thread starter Alec
  • Start date Start date
A

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top