Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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~
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,069
Default 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~

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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~

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 75
Default 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~



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"