charting same cell across multiple tabs

  • Thread starter Thread starter ronfl
  • Start date Start date
R

ronfl

How do you create a chart reference to that it will chart the same cell
but across a range of tabs.

Example, I have a years worth of tabs on a sheet, MMDDYYY, all with the
same format on the sheet. I have a value that is in the same cell on
each tab and I want to see the trend over several months, from tab x to
tab y.

I thought this would be the formula: ='08042003:10142003'!$R$4

But I get the error: reference not valid.

Thanks, Ron.
 
See the response to the other question on the same subject in the same
newsgroup.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top