Sep 12 2021 12:28 AM
Sep 12 2021 03:56 AM
Solution@ChristofWalter You don't show how your data looks like, but if the data is in a structured table, you could use a slicer (multi-select) to set the dimensions of the chart See attached. If this doesn't make sense, please upload a file that resembles your real life data and chart.
Sep 15 2021 09:04 AM
@Riny_van_Eekelen, many thanks, that nearly nails it. Promising track!
Now I would like the use to select in a cover sheet of the workbook, which dimensions to include in the assessment. Is there any way in which I can make the slicer settings conditional on cell values (or control boxes) elsewhere?
Thnaks in advance
Sep 15 2021 09:30 PM
@ChristofWalter I guess you can do this with VBA. Reading out values of cells and then apply these to the auto filter of the data table or slicer settings. However, that's beyond my comfort zone. Personally, I don't understand why you couldn't use a slicer in the cover sheet, but that may because you still haven't given away any clues on how your data is structured, how your cover sheet looks like and how it is to interact with that data.
Sep 24 2021 04:53 AM
Hi @ChristofWalter hope you are doing well.
I attached sample sheet with simple Radar chart and multi axes Radar chart. Data refresh in chart automatically as you change you data selection.
No coding required this provide nocode solution.
You can check here for Microsoft Excel & Office 365.
And if you are comfortable with Google Sheets, you can find here.
Thanks
Sep 12 2021 03:56 AM
Solution@ChristofWalter You don't show how your data looks like, but if the data is in a structured table, you could use a slicer (multi-select) to set the dimensions of the chart See attached. If this doesn't make sense, please upload a file that resembles your real life data and chart.