I have bunch of data that's associated with "number of days". i.e. day 5
it's 3%, day 21 is 15%, day 90 is 25%. I like to plot those in a line graph
so I can see the change of percentage according to number of days that's
progresses so far. If I just plot those 3 data points, I would simply get all
3 points equal space of each other, not reflecting the time difference in the
number of days, i.e. 16 days between first 2 points, 69 days between next 2.
How do I adjust the X axis to change this?

Since you're plotting number of days (plain numbers, not dates), you'll need
a value axis for the x axis. You'll need to use an x-y (scatter) chart
type. Most other chart types use category axes for X, so you get equal
spacing regardless of x value.
--
Earl Kiosterud
www.smokeylake.com

"namsilat" wrote in message
...
I have bunch of data that's associated with "number of days". i.e. day 5
it's 3%, day 21 is 15%, day 90 is 25%. I like to plot those in a line
graph
so I can see the change of percentage according to number of days that's
progresses so far. If I just plot those 3 data points, I would simply get
all
3 points equal space of each other, not reflecting the time difference in
the
number of days, i.e. 16 days between first 2 points, 69 days between next
2.
How do I adjust the X axis to change this?

How do I plot a curve to join just the percent dots on XY dots, preferably in
a parabolic curve? I tried using XY line charts, they are also plotting the
days in a straight line.

You mean a smoothed line connecting points? Double click the series, and
on the Patterns tab, check the Smoothed Line checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


namsilat wrote:

How do I plot a curve to join just the percent dots on XY dots, preferably in
a parabolic curve? I tried using XY line charts, they are also plotting the
days in a straight line.

I tried that already. It's not really a "smooth line" joining the dots. The
end result was bunch of "broken" lines, with most dots not connected, and
each line joining 2 closest 2 dots.

How many "dots" are you talking about? Are there gaps between data in
the worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


namsilat wrote:
I tried that already. It's not really a "smooth line" joining the dots. The
end result was bunch of "broken" lines, with most dots not connected, and
each line joining 2 closest 2 dots.

The example I tried so far has 7 dots, so there are 3 lines joining 2 dots
each, with final dot not connected. As for the distance between the dots,
that was the entire pooint of my original question. These are set up as
number of days, so not every day there is a data point. I was hoping Excel
would try to connect them in a smooth curve. The overall curve should look
like a parabola, I just need some graph linking it to make it presentable.

I meant gaps in the worksheet. Blank cells.

You can change the way the chart treats blanks. By default it leaves a
gap in the chart (if it's truly a blank, no formula that returns "",
which only looks like a blank). Select the chart, go to Tools menu
Options Chart tab, and change the Plot Blanks As setting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


namsilat wrote:
The example I tried so far has 7 dots, so there are 3 lines joining 2 dots
each, with final dot not connected. As for the distance between the dots,
that was the entire pooint of my original question. These are set up as
number of days, so not every day there is a data point. I was hoping Excel
would try to connect them in a smooth curve. The overall curve should look
like a parabola, I just need some graph linking it to make it presentable.