Excel Charts - Time line for random points on X axis
 

I am working on a chart with the data tracked in a scientific experiment
where the time intervals are not equal.

The first point is at 9 weeks, next at 6 months and tne next at 12 months.
How do I represent the spaces between these points propionate to the time
interval between these points? Please help. I could not find it in the book
-- may be I don't know the exact term that is applied to this.

Thanks for your help

Excel Charts - Time line for random points on X axis
 

Anjalika,

In order to have Excel treat the X axis as "time" and to display your data
appropriately, you need to do a few things:

1) Make sure that your X values are recognized by Excel as dates and not
text. (To double-check, change the format of the cells to a different date
format. If any do not change to the new format, Excel doesn't recognize them
as dates).

2) Choose the line, bar or column chart option (not a scatter XY chart)

3) If the previous two steps are successful, when you make the chart, under
"Chart Options" , Axes (tab) you should be able to select "time-scale" as the
format of the axis.

Good luck,

Heidi



"Anjalika Silva" wrote:

I am working on a chart with the data tracked in a scientific experiment
where the time intervals are not equal.

The first point is at 9 weeks, next at 6 months and tne next at 12 months.
How do I represent the spaces between these points propionate to the time
interval between these points? Please help. I could not find it in the book
-- may be I don't know the exact term that is applied to this.

Thanks for your help

Excel Charts - Time line for random points on X axis
 

Heidi,

Thank you. I will try this.

Anjalika

"Heidi" wrote:

Anjalika,

In order to have Excel treat the X axis as "time" and to display your data
appropriately, you need to do a few things:

1) Make sure that your X values are recognized by Excel as dates and not
text. (To double-check, change the format of the cells to a different date
format. If any do not change to the new format, Excel doesn't recognize them
as dates).

2) Choose the line, bar or column chart option (not a scatter XY chart)

3) If the previous two steps are successful, when you make the chart, under
"Chart Options" , Axes (tab) you should be able to select "time-scale" as the
format of the axis.

Good luck,

Heidi



"Anjalika Silva" wrote:

I am working on a chart with the data tracked in a scientific experiment
where the time intervals are not equal.

The first point is at 9 weeks, next at 6 months and tne next at 12 months.
How do I represent the spaces between these points propionate to the time
interval between these points? Please help. I could not find it in the book
-- may be I don't know the exact term that is applied to this.

Thanks for your help