Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |