Prev: How do I make a chart based upon time sheets?
Next: Subtracting curves
From: David on 25 Jun 2008 09:12
Jon,
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.
Thanks
From: Jon Peltier on 25 Jun 2008 12:21
Too bad you deleted the post you were replying to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David" <David(a)discussions.microsoft.com> wrote in message
news:E750BDD8-045D-4809-BF1D-BA1A2E4361BB(a)microsoft.com...
> Jon,
> 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.
> Thanks


From: Del Cotter on 25 Jun 2008 13:56
On Wed, 25 Jun 2008, in microsoft.public.excel.charting,
Jon Peltier <jonxlmvpNO(a)SPAMpeltiertech.com> said:
>"David" <David(a)discussions.microsoft.com> 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 <jonxlmvpNO(a)SPAMpeltiertech.com> said:
>"Del Cotter" <del(a)branta.demon.co.uk> wrote in message
>> Midjack <Midjack(a)discussions.microsoft.com> 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 del(a)branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.
From: Jon Peltier on 25 Jun 2008 15:59
I figured it was something like that. Too lazy to look it up.

Here's the protocol, which doesn't work in 2007 (doh! MS broke the
independence of the XY and line series in a combo chart with a date scale
axis).

Make a series with two points, like the min and max of your X axis
(date-time), and zero y values. Format the axis as you like it, and format
the series to be invisible (no line, no markers). Copy the XY data for the
XY series, select the chart, use Paste Special to add the data as a new
series. Right click this series, Chart Type, choose XY. Right click the
series (now XY), Format, and move it back to the primary axis. Repeat to add
more XY series if necessary.

I have an upcoming series for my blog which will deal with category axes,
but I need more time to make it pretty.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" <del(a)branta.demon.co.uk> wrote in message
news:I+Lvq1B1aoYIFwYn(a)branta.demon.co.uk...
> On Wed, 25 Jun 2008, in microsoft.public.excel.charting,
> Jon Peltier <jonxlmvpNO(a)SPAMpeltiertech.com> said:
>>"David" <David(a)discussions.microsoft.com> 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 <jonxlmvpNO(a)SPAMpeltiertech.com> said:
>>"Del Cotter" <del(a)branta.demon.co.uk> wrote in message
>>> Midjack <Midjack(a)discussions.microsoft.com> 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
> del(a)branta.demon.co.uk,
> which goes to a spam folder-- please send your email to del3 instead.


From: David on 26 Jun 2008 03:17
Thanks for that Jon (and sorry about deleting post last time)
I am using Excel 2002
I followed your protocol and produced a chart but the xy data did not quite
line up with the category x axis like i was hoping.
Here's my numbers:
Line chart: (01/01/01, 0) (03/01/01, 0)
set xmin = 01/01/01, set xmax = 04/01/01
xy data: (01/01/01 05:00,1) (03/01/01 17:00, 4)
after copy, paste special, chart type = xy, format\axis\primary axis
I find that the 2nd xy data point is out of position in the 04/01/01
interval on the x category axis (rather than 17/24ths along the 03/01/01
interval as hoped for)
Is this in line with your expectation?
Thanks


"Jon Peltier" wrote:

> I figured it was something like that. Too lazy to look it up.
>
> Here's the protocol, which doesn't work in 2007 (doh! MS broke the
> independence of the XY and line series in a combo chart with a date scale
> axis).
>
> Make a series with two points, like the min and max of your X axis
> (date-time), and zero y values. Format the axis as you like it, and format
> the series to be invisible (no line, no markers). Copy the XY data for the
> XY series, select the chart, use Paste Special to add the data as a new
> series. Right click this series, Chart Type, choose XY. Right click the
> series (now XY), Format, and move it back to the primary axis. Repeat to add
> more XY series if necessary.
>
> I have an upcoming series for my blog which will deal with category axes,
> but I need more time to make it pretty.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Del Cotter" <del(a)branta.demon.co.uk> wrote in message
> news:I+Lvq1B1aoYIFwYn(a)branta.demon.co.uk...
> > On Wed, 25 Jun 2008, in microsoft.public.excel.charting,
> > Jon Peltier <jonxlmvpNO(a)SPAMpeltiertech.com> said:
> >>"David" <David(a)discussions.microsoft.com> 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 <jonxlmvpNO(a)SPAMpeltiertech.com> said:
> >>"Del Cotter" <del(a)branta.demon.co.uk> wrote in message
> >>> Midjack <Midjack(a)discussions.microsoft.com> 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
> > del(a)branta.demon.co.uk,
> > which goes to a spam folder-- please send your email to del3 instead.
>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: How do I make a chart based upon time sheets?
Next: Subtracting curves