Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marcus
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
How do you create a complicated pivot table graph? Natalia Kozyura Charts and Charting in Excel 1 April 7th 05 02:52 AM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
How to increase the size of a Pivot Table Graph cdavidson Excel Discussion (Misc queries) 1 March 16th 05 03:20 PM
Pivot Table Auto Update Data Source? Ket Excel Worksheet Functions 1 February 18th 05 11:14 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"