Posted to microsoft.public.excel.charting
|
|
Time-date chart plotting
Many thanks Del. That seems to work fine after a little tinkering with both
of the axes.
"Del Cotter" wrote:
On Fri, 7 Mar 2008, in microsoft.public.excel.charting,
Midjack said:
How can I create a time-date graph such that the values are plotted at the
correct time positions within the date range rather than all on the date
vertical axis?
Choose Chart type XY (Scatter) instead of Line. Line has only the
options of Category (which won't distribute the values properly) and
Time-scale (which, for some bizarre reason, Microsoft limits to whole
days only - no times available).
Time-scale can sometimes be useful as a sort of Interval scale for Line
and Area chart types, but because it only does integers, not fractions,
it's no good to you here. Only a proper interval/interval chart type
will do.
Also, make sure the X values are proper "date plus time" format all in
one cell. A date in one cell and a time in another won't work.
--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
|