Reverse sequence of data in graph chart

G

Guest

Hi
After keying in the data into graph chart, the smallest figure appear on top of horizontal chart and largest on top. Using Powerpoint Office 2000, is there anyway to reverse the sequence of the bar to appear largest data on top to the smallest?
Thanks
 
T

Tushar Mehta

In the chart, double-click the y axis. Then, in the resulting dialog
box, select the Scale tab and in there check 'Categories in reverse
order.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
G

Guest

Dear Tushar Mehta,
Thank you
Robin K.

Tushar Mehta said:
In the chart, double-click the y axis. Then, in the resulting dialog
box, select the Scale tab and in there check 'Categories in reverse
order.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
G

Guest

This reverses the categories but puts the axis on top of the graph. How can i
reverse the categories but still have the axis on the bottom of the graph?
 
E

Echo S

I can't tell what Tushar suggested for reversing the categories, but if you
double-click the Y-axis, there is an option for "floor/category crosses at
XXX." Just change that.

Or perhaps you just need to move the axis labels? If that's the case, just
change the Tick Mark Labels on the first tab of the X-axis dialog.
 

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

Top