Presentation in Bar Chart

Good day all,

I hope someone can help me on this.

I have a table :
Product Sales
C 10
A 7
B 5
D 2

The result of the bar chart is like this :

D |xx
B |xxxxx
A |xxxxxxx
C |xxxxxxxxxx
-----------------

But I want it to be like this :
C |xxxxxxxxxx
A |xxxxxxx
B |xxxxx
D |xx
-----------------

Please advise how to get what I want.

Thank you in advance.

Have a nice day.

Best Regards,
Julie

1. Click on the x-axis to select it.
2. Choose FormatSelected Axis
3. On the Scale tab, add a check mark to Categories in reverse order
4. Add a check mark to Value(Y) axis crosses at maximum category
5. Click OK

Julie wrote:
Good day all,

I hope someone can help me on this.

I have a table :
Product Sales
C 10
A 7
B 5
D 2

The result of the bar chart is like this :

D |xx
B |xxxxx
A |xxxxxxx
C |xxxxxxxxxx
-----------------

But I want it to be like this :
C |xxxxxxxxxx
A |xxxxxxx
B |xxxxx
D |xx
-----------------

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you very much, Debra.

It's work as how I want it to be.

Have a nice day.

Best regards,
Julie

Julie,

You're welcome. Thanks for letting me know it worked the way you wanted.
You did a good job of asking your question very clearly, which made it
easy to help you.

Debra

Julie wrote:
Thank you very much, Debra.

It's work as how I want it to be.

Have a nice day.

Best regards,
Julie


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

And you did a good job of answering it, Debra!

Jeeze... I need a vacation.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss


"Debra Dalgleish" wrote in message
...
Julie,

You're welcome. Thanks for letting me know it worked the way you wanted.
You did a good job of asking your question very clearly, which made it
easy to help you.

Debra

Julie wrote:
Thank you very much, Debra.

It's work as how I want it to be.

Have a nice day.

Best regards,
Julie


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi again Debra,

I would like to let you know that your
DynamicColumnChart.xls example has helped me to make my
chart more presentable.

Thank you so much for sharing your expertise with us.

Have a great day.

Best regards,
Julie