Charts

[Zyllian]

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

 

[Jon Peltier]

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

 

[Zyllian]

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

 

[Jon Peltier]

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/ChartsHowTo/ChartFromDiffSheets.html

- Jon

 

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