Chart Question

[tonguencheek]

Hello. I am looking for a way to chart two sets of data with different dates, but use the dates from the one series as the labels for the x-axis

Here's an example.....say I have these two sets of data:

01/15/11         0.5
03/15/11         2
05/15/11         2.5
07/15/11         1.75
09/15/11         2.5
11/15/11          3.5

and I also have:

01/18/11        1
02/25/11        1.5
04/04/11        1.75
05/15/11         2.25
06/29/11        2.5
07/11/11        3
09/25/11       3.2
10/14/11        3.5
11/01/11         4

I would like two lines on the graph, one for each group and the x-axis labels to use the dates from the first group.

Right now when I try to do this I can't figure out how to specify that the data points for the second group have a corresponding set of dates.

Hope this all makes sense, and thanks in advance

 

[Akashwani]

Hi,

I can't paste a copy of the chart I've created, but using this data....

Excel Workbook
	A	B	C	D	E
1	*	Data1	*	*	Data2
2	15/01/2011	0.5	*	18/01/2011	1
3	15/03/2011	2	*	25/02/2011	1.5
4	15/05/2011	2.5	*	04/04/2011	1.75
5	15/07/2011	1.75	*	15/05/2011	2.25
6	15/09/2011	2.5	*	29/06/2011	2.5
7	15/11/2011	3.5	*	11/07/2011	3
8	*	*	*	25/09/2011	3.2
9	*	*	*	14/10/2011	3.5
10	*	*	*	01/11/2011	4
Sheet7

I have created a chart that has the dates along the bottom axis from the first data range. If that is what you require, in 2007, right click the axis, Format Axis, Text Axis.

I hope that works.

Ak

 

[tonguencheek]

I'm using 2003, I don't see that option when I go to format axis.

I do have the right date on the bottom, but the issue is that excel isn't recognizing that the second set of data corresponds to a different date. So for example, for the second line using the second group, it plots 1 on 01/15/11, 1.5 on 03/15/11 etc. instead of lining up the points to the dates I want

 

[Akashwani]

Hi,

Take a look here to see if any of these fit the chart style you require..


tonguencheek.xls

Ak

 

[tonguencheek]

Wow, thanks so much for taking the time to help!

Looks like the first chart (one in the top left) is the closest. The only issue is that the data points for "data2" aren't lining up to the dates that they correspond to. Instead, those points are plotted with the date from "data1". As an example 1.75 from data 2 is lining up to 05/15/11 instead of 04/04/11. The last three points aren't lining up to any date either.

Hope this makes sense

 

[Akashwani]

No problem.
The more I can help the more I can learn, the more I can help.
Take a look at this file to see if it does what you want...


tonguencheek.xls

If this doesn't work then I'm sorry, I'm all out of ideas.

Fingers crossed.

Ak

 

[tonguencheek]

Unfortunately that doesn't seem to work either as the dates along the x axis aren't in order.

I would be fine with a constant scale on the x axis - say the 15th of every month, but I need to have two lines on the graph that use points on different dates.

 

[Akashwani]

Hi,

This is my last offering on this, sorry, I'm all out of ideas, unless you can provide a link to a file that I can view.

Excel Workbook
	A	B	C	D	E	F
1			Data1			Data2
2	15/01/2011	15/01/2011	0.5		18/01/2011	1
3	15/02/2011	15/03/2011	2		25/02/2011	1.5
4	15/03/2011	15/05/2011	2.5		04/04/2011	1.75
5	15/04/2011	15/07/2011	1.75		15/05/2011	2.25
6	15/05/2011	15/09/2011	2.5		29/06/2011	2.5
7	15/06/2011	15/11/2011	3.5		11/07/2011	3
8	15/07/2011				25/09/2011	3.2
9	15/08/2011				14/10/2011	3.5
10	15/09/2011				01/11/2011	4
11	15/10/2011
12	15/11/2011
13	15/12/2011
Sheet7

Add a new column of dates and use that as your date range.


tonguencheek.xls

I'm sorry if that doesn't work for you.

Ak