It has been about 2 years from the last time I worked with Excel. At that
time I had lots of charts and lots of worksheets tracking units, production
and so on. I would have 2 or 3 master sheets that took data from each sheet.
So here is my issue. I have made a workbook for myself and need to chart like
data from the months but when I try to get the serries I keep getting errors.
So the way I did it before is not working. Any Ideas on how I can get this
chart to work as I need it?

Zyl

What are you trying to do? How are you trying to do it? What does the data
look like? Where is the data coming from? What are the errors?

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


"Zyllian" wrote in message
...
It has been about 2 years from the last time I worked with Excel. At that
time I had lots of charts and lots of worksheets tracking units,
production
and so on. I would have 2 or 3 master sheets that took data from each
sheet.
So here is my issue. I have made a workbook for myself and need to chart
like
data from the months but when I try to get the serries I keep getting
errors.
So the way I did it before is not working. Any Ideas on how I can get this
chart to work as I need it?

Zyl

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

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

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