ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Need help with axis (https://www.excelbanter.com/new-users-excel/160228-need-help-axis.html)

Heiji1412

Need help with axis
 
Hello~

Is there a way so that the x-axis starts at the same 0 point as the y-axis?

I suppose it's easier to explain with pictures
http://img2.freeimagehosting.net/ima...785076464e.jpg

I want to make it so that the 0 on the x-axis uses the same 0 that is on the
y-axis.

I can cut out the 0 manually from the x-axis so it starts at 5, but then it
doesn't start from 0, it starts from 5.

Here is the data,
http://img2.freeimagehosting.net/ima...0d8f4a85b9.jpg

Thanks~

John

Need help with axis
 
Have you used an x-y scatter graph. That should go through the 0,0 point for
you
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Heiji1412" wrote:

Hello~

Is there a way so that the x-axis starts at the same 0 point as the y-axis?

I suppose it's easier to explain with pictures
http://img2.freeimagehosting.net/ima...785076464e.jpg

I want to make it so that the 0 on the x-axis uses the same 0 that is on the
y-axis.

I can cut out the 0 manually from the x-axis so it starts at 5, but then it
doesn't start from 0, it starts from 5.

Here is the data,
http://img2.freeimagehosting.net/ima...0d8f4a85b9.jpg

Thanks~


Wondering[_2_]

Need help with axis
 
The x-axis does start at 0, the same 0 as the y-axis. Excel centers the data
series in the plot area. The 0, 5, 10, 15, 30, 45 are labels, not values.

"Heiji1412" wrote in message
...
Hello~

Is there a way so that the x-axis starts at the same 0 point as the
y-axis?

I suppose it's easier to explain with pictures
http://img2.freeimagehosting.net/ima...785076464e.jpg

I want to make it so that the 0 on the x-axis uses the same 0 that is on
the
y-axis.

I can cut out the 0 manually from the x-axis so it starts at 5, but then
it
doesn't start from 0, it starts from 5.

Here is the data,
http://img2.freeimagehosting.net/ima...0d8f4a85b9.jpg

Thanks~




Heiji1412

Need help with axis
 
Ah yeah, that did, thanks both of you~

Oh, I know that the x-axis starts at 0, but it just looks better if they
both start at the same point.

"John" wrote:

Have you used an x-y scatter graph. That should go through the 0,0 point for
you
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Heiji1412" wrote:

Hello~

Is there a way so that the x-axis starts at the same 0 point as the y-axis?

I suppose it's easier to explain with pictures
http://img2.freeimagehosting.net/ima...785076464e.jpg

I want to make it so that the 0 on the x-axis uses the same 0 that is on the
y-axis.

I can cut out the 0 manually from the x-axis so it starts at 5, but then it
doesn't start from 0, it starts from 5.

Here is the data,
http://img2.freeimagehosting.net/ima...0d8f4a85b9.jpg

Thanks~



All times are GMT +1. The time now is 08:29 AM.

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