View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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