Forum Discussion

ChristofWalter's avatar
ChristofWalter
Copper Contributor
Sep 12, 2021
Solved

Excel radar chart with variable number of axes

I am trying to create a radar chart that displays the results of an environmental assessment. The crux is that I need a chart that is able to change the selection of axes that are displayed from a ...
BI & Data Analysis
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 12, 2021

    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.

     

Qaiser_j's avatar
Qaiser_j
Brass Contributor
Sep 24, 2021

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 https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

 

And if you are comfortable with Google Sheets, you can find https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

 

Thanks

 

 

Resources