Chart dont update when source data changes

Hi all,

I have a chart that won't update if the source data changes. My source data is dynamic regarding the content but the range is fixed. Both labels and series change in the fixed range. Neither lables nor the columns in the chart changes when the source data changes. The source data is based on formulas. What the he.. am i doing wrong?

I have automatic calculation.

Pivot charts don't uppdate automatically when source data changes. You either have to refresh it manually: select graphh -> Analyze -> Refresh or include some code. See here: http://www.get-digital-help.com/2011...able-in-excel/

Thanks for the reply. It is not a pivot chart. With data source i meant the fixed range that the chart is based on. When the values in that range changes the chart dont change with it.