Showing 2 Values in a Pie Chart


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.



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!



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
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login