If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Presentation in Bar Chart
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 |
#3
|
|||
|
|||
Presentation in Bar Chart
Thank you very much, Debra.
It's work as how I want it to be. Have a nice day. Best regards, Julie |
#4
|
|||
|
|||
Presentation in Bar Chart
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 |
#5
|
|||
|
|||
Presentation in Bar Chart
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 |
#6
|
|||
|
|||
Presentation in Bar Chart
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 |
Thread Tools | |
Display Modes | |
|
|