|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 6th, 2007, 10:06 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
chart error message / work sheet not open ?
I have a chart that I want to add a new series of data.
I get an error message saying "Reference not valid. Renerence must be to an open worksheet" But the chart and the data are in the same workbook. I can go to any worksheet. Why won't it chart? Any suggestions? Ron 
|
|
#2
July 7th, 2007, 12:17 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
chart error message / work sheet not open ?
How are you referencing the data?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... I have a chart that I want to add a new series of data. I get an error message saying "Reference not valid. Renerence must be to an open worksheet" But the chart and the data are in the same workbook. I can go to any worksheet. Why won't it chart? Any suggestions? Ron
|
|
#3
July 17th, 2007, 08:16 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
chart error message / work sheet not open ?
Hey Jon ! Thanks for your question.
The chart was copied from another workbook into this new workbook But the data page was not copied . I wanted to add a new line on the chart using data from another page in the new workbook. That's when I got the error message. Your question made me open the old workbook to check the source of the old data. When the old workbook was open , I could add new lines on the chart in the new workbook.. Problem solved! Thanks Again "Jon Peltier" wrote: How are you referencing the data? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... I have a chart that I want to add a new series of data. I get an error message saying "Reference not valid. Renerence must be to an open worksheet" But the chart and the data are in the same workbook. I can go to any worksheet. Why won't it chart? Any suggestions? Ron
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
