two rows of data in one series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Jack Banyas said:
I would like to create a graph plotting two continuous years of monthly
Click to expand...
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.
Click to expand...
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.
 
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/
_______
 
Back
Top