Thanks for the info. Now that you said that I have been thinking and what I
was doing was taking grand totals for each month and putting it into a chart
with 12 months on it.

"Jon Peltier" wrote:

You cannot combine data from different worksheets in this manner. (You never
could before, by the way.)

This web page describes how to deal with data from different worksheets:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

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


"Zyllian" wrote in message
...
My source data looks like this:

='info Oct'!$C9:$C36 (Here I want to include Sept and Nov) I have tried
'+'info Nov'! (then the data sourcd) the + is passing the error.

It is all numbers from a work sheet named Sept Oct Nov.

I have done it before but for some reason I get a error and it is bad
data.
So I just do it a month at a time. It would be better if I could do 3
months
on one chart.


Zyllian