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.