Doughnut chart plot on second axis

RaviWildcat

Board Regular
Joined
Jun 18, 2010
Messages
97
Hi Everyone -

I'm trying to create some cool doughnut charts for a dashboard. I've found some neat pointers on youtube, and they both say the same thing

1. Create doughnut chart with dummy data - Y Series = 1,1,1,1,1,1 (20 times). OK


View attachment 26594



2. Select the data you actually want to capture and place on the same doughnut chart

1606162390810.png



3 - Highlight the actual series - select change series chart type, and plot it on a second axis
(I'm not seeing an option to select the series chart type, so I'm not seeing an option to plot on a second axis. I've tried clicking on the outside series but don't have that option

I'm using microsoft excel for mac version 16.3. Is there someplace else I need to click?

Thanks,
Ravi
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,118,305
Messages
5,571,443
Members
412,393
Latest member
JayD
Top