I would like to create a 3D pie chart that shows Dollar values in the pie area and percentages around the outside of the pie. I can only find where it will show the 2 values next to each other in a chosen area of the chart. I thought you could do that in earlier versions of Excel.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Showing 2 Values in a Pie Chart
0
Answers
0
Selected Answer
Hi there!
This is one of those "more annoying than it should be things" in Excel.
- Delete the chart and create a new one by selecting cells A2:C10 and clicking Pie on the Insert tab.
- Right-click over the pie chart pieces and click Format Data Series...
- In the Series Options section click the option for "Secondary Axis" and hit OK.
- Go to the Layout tab and select Series 1 from the drop-down menu in the upper left of the ribbon menu.
- Click the Data Labels button and click Outside End.
- Repeat the last two steps for Series 2 but select Inside End this time.
I hope this can help you!
Discussion
Thank You for your answer as it was helpful. This appears to work for a 2D chart but it doesn't work for a 3D chart. The Secondary Axis option doesn't come up when you've selected a 3D pie chart. It sounds like I'll need to stick with 2D to show both values.
CherylM (rep: 2) Mar 16, '17 at 10:45 am