I'm interested in incorporating dynamic chart selection into a spreadsheet. I'm picturing a dashboard of sorts in which the user would select a variable (e.g., inflation) and a chart for that variable would appear in a designated spot. Simplistically, you can think about it as cell A1 containing either a 1 or a 2. There are two different charts somewhere else in the spreadsheet. If the user enters a 1 in cell A1, the first of these charts appears anchored in cell B2 . If the user enters a 2 in cell A1, a completely different chart appears anchored in cell B2. The attached spreadseet illustrates this.
I can make things happen for some situations by using a single chart and then having the data for that chart be conditional on what is entered in cell A1, but it is quite tricky when the different charts do not have similar formats. For example, I don't see a way to make it work when one chart is a pie chart and another is a line chart. I'd appreciate any advice you might have.
Bookmarks