Forum Discussion
Excel radar chart with variable number of axes
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.
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.
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
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.