ploting properly spaced "day" chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
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/
_______
 
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/
_______
 
Back
Top