S
sidata
Please help.
I have a chart "Chart2" that is in sheet called "Filtered"
Source Data is "=FILTERED!$C$7:$O$10"
FILTERED!$C$7:$O$10 is linked to sheet that i run a filter on, the data
changes when I run filter.
The problem is that the chart will not change to match what is in the Source
Data.
Have forced recalculation and saved file and chart still dosn't update to
match change Source Data.
Close and reopen file and chart will ajust to match source Data.
What can I do to get chart to match data?
I have a chart "Chart2" that is in sheet called "Filtered"
Source Data is "=FILTERED!$C$7:$O$10"
FILTERED!$C$7:$O$10 is linked to sheet that i run a filter on, the data
changes when I run filter.
The problem is that the chart will not change to match what is in the Source
Data.
Have forced recalculation and saved file and chart still dosn't update to
match change Source Data.
Close and reopen file and chart will ajust to match source Data.
What can I do to get chart to match data?