How do I make a chart with multiple series/different labels?

[cmikecs]

I am trying to create a 3D Chart showing data from multiple series. Most of
the labels are different in each different series as is the data. I want it
to chart all of the different labels even though they don't have the same pl
ace in each series. Any help is greatly appreciated.

Example of my problem:
Series: 24-Jan
Name:="24-Jan"
Values: ='1-24'!$B$2:$B$31

Series: 25-Jan
Name:="25-Jan"
Values: ='1-25'!$B$2:$B$31

They all have the same Category X Axis Label: ='1-24'!$A$2:$A$31

I think I need a different Category X Axis Label for each series/date on the
chart.

 

[cmikecs]

Re: How do I make a chart with multiple series/different lab

 

[jdee]

Re: How do I make a chart with multiple series/different lab

I'm not sure if this is what you are asking for. If you are asking for the dates on the X Axis and your data then see the layout at bottom.

Choose the chart wizard, select colum with 3d visual effect, choose next, choose the radio button series in rows, and then continue on adding your labels, titles, etc. This will give you dates on x, data on y.

Just tried it and am using office 2000.

Book2
	A	B	C	D
1		24-Jan	25-Jan	26-Jan
2	data1	1	4	7
3	data2	6	2	2
4	data3	9	6	19
5	data4	7	1	20
6	data5	2	3	7
Sheet1

 

[cmikecs]

Re: How do I make a chart with multiple series/different lab

I want to be able to import multiple tables with multiple different labels. Each table would be a data for a different date. The labels in column A go by RANK so they will vary from table to table and even not be there most of the time. Whenever there is a new label for column A, I want it to add it to the chart/output...