ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Changing the origin (https://www.excelbanter.com/charts-charting-excel/165328-changing-origin.html)

Katie

Changing the origin
 
Hi,
I'm desperate here. I'm trying to plot data into a line graph. I need the
horizontal axis to start (at the origin) with the larger numbers and decrease
in numerical value as it extends out. No matter which way I enter the data it
keeps automatically setting the origin at 0,0. Any suggestions?

Bernard Liengme

Changing the origin
 
Have you tried Format Axis and checking the Reverse Order box?
You may need to change the Crosses Axis setting
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"katie" wrote in message
...
Hi,
I'm desperate here. I'm trying to plot data into a line graph. I need the
horizontal axis to start (at the origin) with the larger numbers and
decrease
in numerical value as it extends out. No matter which way I enter the data
it
keeps automatically setting the origin at 0,0. Any suggestions?





All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com