This may be too complicated to describe or understand a solution, but I'll try...
I've got one sheet (tab) of data. I used data on that tab to create pivot tables and generate pie and bar charts on another tab in the same spreadsheet. From what I can tell, there isn't a maintained connection between these charts and the original data. I can change something on the data tab, and the charts on the other tab don't update to reflect the change.
I was wanting to set things up so that I'd have all these charts, and if I filter data on the first tab, the pie and bar charts would update.
For instance, I'm tracking age, gender, and device (smartphone, tablet, laptop, PC, etc.) usage. I have a nice pie chart showing me this device usage for all my participants. Now, I want to see how that device usage changes if I just look at Gen X users, or Baby boomers. So, I'd like to be able to filter out some of my age ranges, and see how those charts change. If I make a change to the filter or put things back the way they were, the charts would go back to the way they looked before.
How would I go about doing this? Is there a way of setting up charts so they are "live" and still connected to the data they represent?
Thanks!
I've got one sheet (tab) of data. I used data on that tab to create pivot tables and generate pie and bar charts on another tab in the same spreadsheet. From what I can tell, there isn't a maintained connection between these charts and the original data. I can change something on the data tab, and the charts on the other tab don't update to reflect the change.
I was wanting to set things up so that I'd have all these charts, and if I filter data on the first tab, the pie and bar charts would update.
For instance, I'm tracking age, gender, and device (smartphone, tablet, laptop, PC, etc.) usage. I have a nice pie chart showing me this device usage for all my participants. Now, I want to see how that device usage changes if I just look at Gen X users, or Baby boomers. So, I'd like to be able to filter out some of my age ranges, and see how those charts change. If I make a change to the filter or put things back the way they were, the charts would go back to the way they looked before.
How would I go about doing this? Is there a way of setting up charts so they are "live" and still connected to the data they represent?
Thanks!