updating a graph of a pivot table automatically

tealeaf · May 21st, 2002, 07:09 AM

this is similar to a question i asked earlier, i want the graph to be updated automatically when the values of the pivot table are changed. what i have is a pivot table and a scatter (points) graph.

Ian Mac · May 21st, 2002, 07:11 AM

Quote:

On 2002-05-21 06:09, tealeaf wrote:
this is similar to a question i asked earlier, i want the graph to be updated automatically when the values of the pivot table are changed. what i have is a pivot table and a scatter (points) graph.

No need to start another Thread.

If you weren't happy with my reply, continue that thread and let people know what was wrong with it. Then we can best see how to answer your question.

Regards

tealeaf · May 21st, 2002, 07:16 AM

Quote:

On 2002-05-21 06:11, Ian Mac wrote:

Quote:

On 2002-05-21 06:09, tealeaf wrote:
this is similar to a question i asked earlier, i want the graph to be updated automatically when the values of the pivot table are changed. what i have is a pivot table and a scatter (points) graph.

No need to start another Thread.

If you weren't happy with my reply, continue that thread and let people know what was wrong with it. Then we can best see how to answer your question.

Regards

sorry...but i`m no longer trying to make the graph in VBA so i thought it was a different topic, i liked ur solution but my boss wants it done this way. thanks anyway.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 07:09 AM	#1
tealeaf Board Regular Join Date: May 2002 Location: mtl, canada Posts: 160	this is similar to a question i asked earlier, i want the graph to be updated automatically when the values of the pivot table are changed. what i have is a pivot table and a scatter (points) graph.