ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make excel start with 0 instead of 1 for my x values? (https://www.excelbanter.com/excel-discussion-misc-queries/49914-how-do-i-make-excel-start-0-instead-1-my-x-values.html)

mountainsol

How do I make excel start with 0 instead of 1 for my x values?
 
I have a set of data and I am plotting population levels on the y axis and
time on the x axis. I want to start at time of zero with an initial
population. I can't figure out how to make excel start at 0 instead of 1.
My first data point is ( 1,y1) and it should be (0,y1) to be correct.

Nikki

on your graph right click on the y-axis-- choose format
axis--scale--change the minmum to 0. hope it works.
regards,
Nikki

"mountainsol" wrote:

I have a set of data and I am plotting population levels on the y axis and
time on the x axis. I want to start at time of zero with an initial
population. I can't figure out how to make excel start at 0 instead of 1.
My first data point is ( 1,y1) and it should be (0,y1) to be correct.



All times are GMT +1. The time now is 06:04 AM.

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