 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2006Charts
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 _______ > 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, [quoted text clipped - 9 lines] > > 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/ChartsHowTo/ChartFromDiffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > My source data looks like this: > [quoted text clipped - 10 lines] > > 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. > You cannot combine data from different worksheets in this manner. (You never > could before, by the way.) [quoted text clipped - 24 lines] > > > > Zyllian |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.