View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DanielC DanielC is offline
external usenet poster
 
Posts: 1
Default Chart Source Data

Hi all. I am making some charts and need some help with the cells the chart
references as source data.

I am trying to make it so that I can insert and delete rows while having the
chart reference the original cell, rather then automatically updating and
following the cell when I add or remove rows. Basically trying to do the same
thing in the chart as I can do with a formula by using the "indirect" feature.

Is this possible with a chart? Having to go back in and manually change the
references back to the original cells is time consuming each week.