View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Herb Martin Herb Martin is offline
external usenet poster
 
Posts: 6
Default Trick? for using INDIRECT references in Data Source of Chart?

Is it possible to use INDIRECT references in Data Source of Chart?
If so, is there some trick?

Goal: Chart with several Data ranges which need to be extended
as data is appended to a running list.

I wish to create a cell with the necessary elements to create the
source data reference indirectly.

Or a better way to do this easily....

Thanks

--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]