Invert Chart

[tek9step]

Hi all I have data in negative/Postive value as shown in example.. how can i change the view of chart i.e negative being the top axis and postive being bottom widout having to change the values. Thanks

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[tek9step]

NBVC i think that was bit harsh.. !! But anyway i have changed it the way i can best describe it.

[NBVC]

Just titling you thread "Chart" doesn't say much, we want to achieve a good searchable database...... and besides you also should be posting in the Chart forum.... which I will change for you....

[tek9step]

NBVC Sorry i didnt know there was a chart forum as it is my first time asking a question about chart. Fair enough to your statment ill keep that in mind. Thanks

[Andy Pope]

Select the Y axis and display the Format dialog.

On Axis Options is the checkbox Values in Reverse Order.

[tek9step]

Thank you Andy that was really simple