How do I plot multiple x-axis series in excel charts

#1 11-22-2005, 01:25 PM

I am plotting 3 years of survey data. Survey date is the x axis and count
value is the y axis. Surveys were not conducted on exactly the same date in
each year. In previous versions of excel I could convert the data to a number
(i.e. julian date) Specifiy the minimum and maximum x-axis values and the
data points would be diplayed at the appropriate x-value (date). However in
Excell 2003 I can't seem to do this. I can't specify a scale for the x-axis
and when I try and put specific values in for the x-axis excel will only use
the last one entered and applies these date values to all remaining series.
Any ideas?

#2 11-22-2005, 08:35 PM

If you have a line chart, even with a date axis, the X values are treated as
integer values. Each series in an axis group (primary or secondary) shares X
values. You could make an XY chart instead, where each series can have
distinct X values, or make the chart with the first series as a line series,
then add one or more XY series to it. The XY series can use the line chart
axis with independent values.

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

"bdorr" <bdorr@discussions.microsoft.com> wrote in message
news:913BA3DD-62DC-411A-A968-404718B4F95A@microsoft.com...
>I am plotting 3 years of survey data. Survey date is the x axis and count
> value is the y axis. Surveys were not conducted on exactly the same date
> in
> each year. In previous versions of excel I could convert the data to a
> number
> (i.e. julian date) Specifiy the minimum and maximum x-axis values and the
> data points would be diplayed at the appropriate x-value (date). However
> in
> Excell 2003 I can't seem to do this. I can't specify a scale for the
> x-axis
> and when I try and put specific values in for the x-axis excel will only
> use
> the last one entered and applies these date values to all remaining
> series.
> Any ideas?

#3 11-23-2005, 10:25 AM

Jon,

That did it, THANKS!

"Jon Peltier" wrote:

> If you have a line chart, even with a date axis, the X values are treated as
> integer values. Each series in an axis group (primary or secondary) shares X
> values. You could make an XY chart instead, where each series can have
> distinct X values, or make the chart with the first series as a line series,
> then add one or more XY series to it. The XY series can use the line chart
> axis with independent values.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "bdorr" <bdorr@discussions.microsoft.com> wrote in message
> news:913BA3DD-62DC-411A-A968-404718B4F95A@microsoft.com...
> >I am plotting 3 years of survey data. Survey date is the x axis and count
> > value is the y axis. Surveys were not conducted on exactly the same date
> > in
> > each year. In previous versions of excel I could convert the data to a
> > number
> > (i.e. julian date) Specifiy the minimum and maximum x-axis values and the
> > data points would be diplayed at the appropriate x-value (date). However
> > in
> > Excell 2003 I can't seem to do this. I can't specify a scale for the
> > x-axis
> > and when I try and put specific values in for the x-axis excel will only
> > use
> > the last one entered and applies these date values to all remaining
> > series.
> > Any ideas?
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)