Hello,
I've been searching for a solution to my issue but haven't had any luck. I have a line chart that I'm trying to make change dynamically depending on form control option buttons. There are three buttons/"views" for the chart - one for revenue, one for expense, and one for margin and the source data for the chart updates depending on which button is clicked.
The problem I'm running into is that the revenue source data has three series, but the expense and margin source data each only have two. So when I click on the expense or margin buttons, they still show a blank series. I'm wondering if there is a way to show all three revenue-related series when the revenue button is clicked, but turn off the third series when the expense or margin buttons are clicked?
If it helps, here is how my source data is laid out. When the revenue button is clicked, it shows this data:
When the expense or margin buttons are clicked, it shows this data (series 3 has formulas to show as blank):
Any assistance would be greatly appreciated!!
I've been searching for a solution to my issue but haven't had any luck. I have a line chart that I'm trying to make change dynamically depending on form control option buttons. There are three buttons/"views" for the chart - one for revenue, one for expense, and one for margin and the source data for the chart updates depending on which button is clicked.
The problem I'm running into is that the revenue source data has three series, but the expense and margin source data each only have two. So when I click on the expense or margin buttons, they still show a blank series. I'm wondering if there is a way to show all three revenue-related series when the revenue button is clicked, but turn off the third series when the expense or margin buttons are clicked?
If it helps, here is how my source data is laid out. When the revenue button is clicked, it shows this data:
| Time Period | Series1 | Series2 | Series3 |
2018 | 229 | 428 | 141 |
2019 | 387 | 160 | 306 |
2020 | 469 | 329 | 302 |
2021 | 468 | 128 | 430 |
When the expense or margin buttons are clicked, it shows this data (series 3 has formulas to show as blank):
| Time Period | Series1 | Series2 |
2018 | 229 | 428 |
2019 | 387 | 160 |
2020 | 469 | 329 |
2021 | 468 | 128 |
Any assistance would be greatly appreciated!!
