Is it possible to hide a series in a chart automatically depending on another cell's value.
Edit: I am building a dashboard for social media analytics with charts for different metrics (impressions, engagements, etc.). I would like to allow the chart to be formatted (show different values, i.e. hide Twitter) based on the value in a drop down menu in the top column that will allow you to select and view metrics for either Twitter, LinkedIn, or both at the same time.
Example showing Impressions chart for Twitter & LinkedIn when dropdown selected should only be showing Twitter data in Q2:
Right now, my back end has the static data for each platform for the year, and then smaller 3x3 tables with data from only the months that are in the quarter selected. The charts are built using this dynamic table.
I can hide a chart using macros, but the problem is that I'll have to create and include 3 separate charts (Twitter, LinkedIn, Both) instead of using just the one in that image that shows both, and hiding the series that is not selected.
To make this worse, I also have a feature that compares to the previous quarter results, so that would mean 3 more charts, for a total of 6, which will just weigh down the spreadsheet and create more work to build and format.
Open to any suggestions on how to have 1 chart that will dynamically hide either Twitter or LinkedIn when the dropdown menu is changed.
My closest solution is dynamically changing LinkedIn values to 0 when Twitter is selected, but this causes the bar graph to be off center from the label - it's minor, but still looking for a better solution.