RaviWildcat
Board Regular
- Joined
- Jun 18, 2010
- Messages
- 119
- Office Version
- 365
- Platform
- Windows
- MacOS
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
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
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
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