Unevenly spaced x axis on chart

  • Thread starter Thread starter marcoooooooooo
  • Start date Start date
M

marcoooooooooo

Hi

Trying to make a chart where the x axis is number-of-days
from a start-date, and y axis is a value measured on the
particular date.

For example, the columns may be:

Date Days from Start Measurement
02/12/09 1 120
06/12/09 5 134
09/12/09 8 118
18/12/09 17 109

etc.

I want a line chart showing the measurement vs days
which I can do - BUT...

I would like the x axis (days from start) to be
spaced according to the number of days, which as
you can see from the above are not evenly spaced.
In other words, if there have been several days
between measurements, I want a longer gap on the
x axis than if there have been two measurements
taken on consecutive days: I will try to draw it:

|
|
| .
|
| .
| .
|
| .
|
|
|
+______________________________________________
0 0 0 1 (Days since start)
1 5 8 7

Where "." are the measurements taken on a particular day.

I can't find a way to "spread" the x axis according
to the days-since-start column. The spread of the x
axis seems to be constant and doesn't give a true
picture if measurements are not taken on a regular
basis.

Can anyone suggest a way to achieve this?

Also I would like to be able to add new rows and for
them to get automatically added to the chart. Is that
possible?

I have Excel 2003

Thanks in advance
 
Try re-spacing your data, adding rows between the existing ones. for
instance put three blank rows between the 1 and 5, and two between the 5 and
8, and 8 blank rows between the 8 and the 17. This will "space out" your
chart.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top