Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How to increase the size of a Pivot Table Graph | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions |