View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Diane Diane is offline
external usenet poster
 
Posts: 96
Default Can you create 1 chart that will update based on filtered data?

I have budget data for 120 or so medical centers in rows. I filter this data
by center. Is there a way to create one chart that will present data for
only the center currently selected in the filter or would I have to create
120 diff charts?

Thank you,