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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,118,845
Messages
5,574,621
Members
412,607
Latest member
caner
Top