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..)