SOLVED

Creating Pie charts.......

Copper Contributor

Hi all, 

I been spending hours trying to create a simple pie chart in excel, when i go to insert, excel is not selecting the correct data and i am getting just a blank display, I’m getting so frustrated can anybody help me, i am using excel on my iPad. i have attached a screen shot......

4 Replies
best response confirmed by dougler2020 (Copper Contributor)
Solution
Hello, based on the picture attached, you need to have numeric values only in column C for the chart to work.. It doesn't recognize alphanumeric..

Moreover, Pie Chart is limited to only one series...

@dougler2020 

 

In the picture below, we have alphanumeric values in column B and inserted the Pie Chart which didn't work

Abiola1_0-1582493467284.png

After removing the text, the Pie chart worked perfectly as see in the caption below

Abiola1_1-1582493542923.png

 

@Abiola1 

 

Thank you for your help, it has worked i knew it was something obvious

@dougler2020 

 

You're welcome

1 best response

Accepted Solutions
best response confirmed by dougler2020 (Copper Contributor)
Solution
Hello, based on the picture attached, you need to have numeric values only in column C for the chart to work.. It doesn't recognize alphanumeric..

Moreover, Pie Chart is limited to only one series...

View solution in original post