Home

Pie Chart does not appear after selecting data field

James Terrell
New Contributor

Occasional User of Excel. Trying to plot church budget with a pie chart. Six categories totaling 100%. When I  highlight data field and select "pie chart', chart does not appear in display field (blank field). Switching to "bar chart", everything works fine. Is there some setting that I need to toggle or specify?  Thanks. 

6 Replies

James, could you attach sample file with non-sensitive data?

Thanks for your reply.  I tried to respond on my iPhone but got error message. Forgot to mention that I am using Excel 2016. Thank you.

Jim Terrell

Hi,

 

the sheet you have sent is empty!

Not sure what happened with file. When I opened file just now, data is there.

Can we try one more time? I appreciate your patience.

Jim Terrell

Hello,

option 1: only select the the 2 columns with the data ( don't select the empty columns)

then insert the pie chart

 

option 2: delete the empty columns - then select the 2 columns then insert the pie chart

 

Capture.PNG

Option 1 Worked great! No other issues.

Thank you so much.

Jim Terrell

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies