On Wed, 25 Jun 2008, in microsoft.public.excel.charting,
Jon Peltier said:
"David" wrote
This is just what I need. I've had a go, but am failing miserably so
far. I've been looking at your pages for an example but no joy so far.
If there is a specific example on your site could you please point me
at it.

Too bad you deleted the post you were replying to.

Jon, this is the context:

On Sat, 8 Mar 2008, in microsoft.public.excel.charting,
Jon Peltier said:
"Del Cotter" wrote in message
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

What you could do if you like the way the date axis is formatted (I know I
do), is to make a line chart with a hidden series (no markers or lines) to
control the axis, then add your real data as XY series, using real dates and
times for the X values. These somehow are allowed to display in between
categories and show times other than midnight on the days along the axis.
This combination Line-XY approach also helps to display data where the
series don't have points on the same days. Line chart series are tied to the
dates for the first series, but XY series are independent of each other.

--
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.