So I created a pivot table with a bunch of data I have and I also have a scatterplot that I would like to coordinate with it (ie every time I add a field, the data will appear in the scatter plots and if I want to remove a point from the chart, I can simply uncheck from the pivot table. Here's my problem: when I add or remove data from the pivot table all the other existing data moves to new cells and and chart is thrown off. What's my best solution? (i hope this all makes sense..)
You may be able to use dynamic named ranges.
Or add code to the pivot table update event which would then adjust chart.
Thanks Andy, would you mind explaining?
What do you need explaining?
There are many posts on charts using dynamic named ranges.
The vba code required would greatly depend on your workbook setup. The update event can be located by right clicking the sheet tab with the pivot table on. This will take you to the VBE. Select Workbook in the left hand dropdown. The select the PivotTableUpdate event from the right hand dropdown.
Post an example workbook if you need more help.
Ok, I'm a bit confused, so I've attached a sample. Thanks again!
I might add that I am looking to do something a bit like this next attachment. However, I would like to be able to add more than one selection from the drop down list to create a scatterplot. I would also need each point in the scatter to have a label
Here's the attachment...
Your first example has a pivot table but is based on a file on your server.
Your second file has no pivot table and the chart is not xy scatter.
Now I'm confused, care to explain.
I think I was over complicating things. Came up with a better way since then, thanks for all the help, andy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks