Graph from a PIVOT table: update not working. Please Help!
Hello everyone !
I have an question for experts : I am trying to create a tool to allow users
to see 1 graph the result of a table: let me explain the problem: the table
is a PIVOT table. So when I change the PIVOT table (= it adds different data
in a range of cell determined)
It seems working very well for the first graph (the graph is doen wih the
good data). But when I update the pivot table the graph doesnt make any
changes (it keeps old first data). I have to redefine the source data
manually (the data series are good but the selection is not working!!) . Do
you know a way to solve this? Or is a way to copy the pivot table value as
value only to another sheet ?
Many thanks in advance,
Marcus
|