Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why, when i open a work sheet does a blank sheet open as well | Excel Discussion (Misc queries) | |||
After File Open View Preview get error message | Excel Discussion (Misc queries) | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
Message Input with link to different work sheet | New Users to Excel | |||
File won't open. Error message "too many different cell formats" | Excel Worksheet Functions |