Time Axis Area Chart

[firefly2k8]

Is it possible to plot an area chart with a time axis? I can't get this working.

Thanks,
Martin

Example data:
08/10/2009 09:01 5079.5
08/10/2009 09:02 5081.5
08/10/2009 09:03 5083.5
08/10/2009 09:04 5083.5
08/10/2009 09:05 5083
08/10/2009 09:06 5082.5
08/10/2009 09:07 5082
08/10/2009 09:08 5083.5
08/10/2009 09:09 5080.5
08/10/2009 09:10 5082
08/10/2009 09:11 5079.5
08/10/2009 09:12 5078.5
08/10/2009 09:13 5081
08/10/2009 09:14 5079.5
08/10/2009 09:15 5080.5
08/10/2009 09:16 5081
08/10/2009 09:17 5082.5
08/10/2009 09:18 5080
08/10/2009 09:19 5081.5
08/10/2009 09:20 5079.5
08/10/2009 09:21 5082
08/10/2009 09:22 5081.5
08/10/2009 09:23 5081
08/10/2009 09:24 5081.5
08/10/2009 09:25 5082

[Andy Pope]

Can you post an actual workbook with the chart you have.
Also which version of excel?

[firefly2k8]

Excel version is 2003 SP3

Example of a chart that I would prefer to be an area chart attached.

[zbor]

If it's all in one day you can name series by that date, that would be best.

You can put on X axis right click -> Format axisi -> Number -> Date -> choose date with time.. however, it might became slightly unreadable

[firefly2k8]

Thank you for your response.

I tried it and I don't see how changing the series name helps. Also there is no time and date option, only time or date unless I choose a custom number format. In any case changing to an area chart just makes the chart blank.

Martin

[Andy Pope]

Area will not go down as far as hh:mm.
All values will be plotted at the same point.

You could recalculate the area chart values but it will still be wrong in terms of not being able to plot multiple plots when the x value is repeated.

[firefly2k8]

So we conclude it is not possible. I have tried to find a work around for this before with no success. Seems such a simple thing to want to do.

[Andy Pope]

Not so much impossible as just not accurate enough.