two rows of data in one series

[Jack Banyas]

I would like to create a graph plotting two continuous years of monthly sales. Here is a sample of the data

Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-0
43,034 42,042 - 7,630 27,379 22,601 11,274 44,391 28,615 3,539 32,591 8,570

Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-0
- 56,275 53,481 25,432 17,281 - - - - - - -
I tried to place a "+" between the two data ranges but this didn't work. Basically, I want to see Jan 03 through Dec 04 represented in one line. The above numbers represent the sales of one product. I have several other products which I want to place in the same graph
I appreciate your help and prompt reply
Thank
Jack Banyas

 

[DDM]

Jack, use parentheses and a comma instead of a plus sign:

Category axis labels: =(Sheet1!$A$1:$L$1,Sheet1!$A$4:$L$4)
Values: =(Sheet1!$A$2:$L$2,Sheet1!$A$5:$L$5)

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I would like to create a graph plotting two continuous years of monthly

sales. Here is a sample of the data.

Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03
43,034 42,042 - 7,630 27,379 22,601 11,274 44,391 28,615 3,539 32,591 8,570


Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04
- 56,275 53,481 25,432 17,281 - - - - - - -
I tried to place a "+" between the two data ranges but this didn't work.

Basically, I want to see Jan 03 through Dec 04 represented in one line. The
above numbers represent the sales of one product. I have several other
products which I want to place in the same graph.

 

[Jon Peltier]

If you use Source Data from the Chart menu, you can use the data
selection boxes, select the first area of the range, then hold CTRL
while selecting the second area. Excel will insert the comma and
parentheses for you.

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