Changing X axis values

[ksbigfoot]

I have to use a line graph and
I have a list of numbers for the x axis:
0
0.4375
0.989583333
1.041666667
1.291666667
1.625
1.958333333
2.291666
2.291666667
2.625
2.71875
4.541666667
I would like my X-axis to be labelled 0, 1, 2, 3, 4, 5
It seems like it would be simple to do, but I can't figure it out.
Thank

 

[Stephanie Krieger]

Hi,

If you use a scatter line as the chart type instead of a
line chart (it can look exactly the same as a line
chart), and you don't select any data for the x values,
it will automatically number as 0,1,2,3, etc.

If that doesn't answer your question, feel free to email
the file and I'll try to help.

Best,

Stephanie Krieger
author of Microsoft Office Document Designer
(from Microsoft Press)
e-mail: MODD_2003 @ msn . com
blog: arouet.net

 

[ksbigfoot]

Hi Stephanie,
I do have two lines I need for the Y-axis, so I tried the scatter lin
and I didn't get it to work. I need the TimeInterval on the X axis an
two lines (SumOfD) and (SumOfR) on Y axis. the TimeInterval is liste
in days.
I guess I should post the data I have and you will see what I a
working with (sorry about formatting):
TimeInterval;SumOfD;SumOfR
0;0;*150*
0.4375;150;
0.989583333;;*1039*
1.041666667;150;
1.291666667;381;
1.625;713
1.958333333;950;
2.291666;;*1112*
2.291666667;1039;
2.625;1096;
2.71875;1112;
4.541666667;1112;

Thanks agai

 

[Tushar Mehta]

It isn't clear what you want on the x-axis. Do you want all data
points to be equidistant? Or do you want the x-axis to reflect the
unequal spacing of the x-values?

In other words do you want
Option 1:
|------|-------|------|
0 0.48 0.99 1.04

Or option 2:
|------------|----------------|----|
0 0.48 0.99 1.04

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[ksbigfoot]

Hi Tushar,

I would like the x-axis to have the values: 0,1,2,3,4,5
I would like the y-axis to have the values: 0,50,100,150,...,1200
It should look like:

|------|-------|------|------|------|
0___1____2___3____4___5

**the numbers should not have the underscore, I just didn't know how t
do the spacing.

I would like the value 0.4375 to land between 0 & 1.
Thank

 

[ksbigfoot]

I noticed the formatting in my last post didn't come out correct.
The numbers 0,1,2,3,4,5
should be right underneath each bar (|)
Thanks :

 

[Tushar Mehta]

You didn't answer my question. So, this is a guess.

Create a XY Scatter chart. Ensure that XL selects column 1 as the x-
values.

In the resulting chart, double-click the x-axis. From the scale tab,
set the minimum to zero and the major unit to 1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[ksbigfoot]

Hi Tushar,
Sorry, I guess I misinterpreted you question.
I read the option 1 and option 2 that you posted, and I didn't thin
that I wanted either of them. That is why I thought an example would b
better.
But I will try the XY Scatter chart.
Thanks for pointing me in the right direction.
Very much appreciated :