Forum Discussion

YYAppleFan's avatar
YYAppleFan
Copper Contributor
Jun 17, 2021
Solved

How to change the chart type of a data series(macOS)?

I found a relevant support article here: https://support.microsoft.com/en-us/topic/change-the-chart-type-of-an-existing-chart-c686d8c2-b294-43c0-b744-f54000f51454?ui=en-us&rs=en-us&ad=us#OfficeVersi...
Charting
excel
Excel on Mac
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 17, 2021

    YYAppleFan It's really very simple. Go back to your original chart with the two rings. I believe the inner ring already had the regional data in it.

    Right_click the inner ring, format data series.

    Now set the doughnut hole size to 0%

YYAppleFan's avatar
YYAppleFan
Copper Contributor
Jun 17, 2021
Yep, but in the macOS tablet doesn't tell me how to change the chart type of A DATA SERIES. I can only change the type of the WHOLE chart.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 17, 2021

YYAppleFan Just click on a series in the chart and on the Chart Design ribbon, select Change Chart Type, exactly the same as on the Windows version.

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 17, 2021

      YYAppleFan Not sure what you are trying to achieve, but as far I understand having different chart types in one graph, requires a combo chart type and I don't think you can combine a pie chart with a sunburst chart.

       

       

      • YYAppleFan's avatar
        YYAppleFan
        Copper Contributor
        Jun 17, 2021

        Riny_van_Eekelen However, here's an example from my online class teacher. He successfully combined two different chart types into one chart using the the Windows version of Excel. The document is attached below. 

         

Resources