SOLVED
Home

Creating Pie charts.......

%3CLINGO-SUB%20id%3D%22lingo-sub-1189717%22%20slang%3D%22en-US%22%3ECreating%20Pie%20charts.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189717%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20been%20spending%20hours%20trying%20to%20create%20a%20simple%20pie%20chart%20in%20excel%2C%20when%20i%20go%20to%20insert%2C%20excel%20is%20not%20selecting%20the%20correct%20data%20and%20i%20am%20getting%20just%20a%20blank%20display%2C%20I%E2%80%99m%20getting%20so%20frustrated%20can%20anybody%20help%20me%2C%20i%20am%20using%20excel%20on%20my%20iPad.%20i%20have%20attached%20a%20screen%20shot......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189794%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Pie%20charts.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189794%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566182%22%20target%3D%22_blank%22%3E%40dougler2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20picture%20below%2C%20we%20have%20alphanumeric%20values%20in%20column%20B%20and%20inserted%20the%20Pie%20Chart%20which%20didn't%20work%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1582493467284.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172857i2D6667438B3A93F7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1582493467284.png%22%20alt%3D%22Abiola1_0-1582493467284.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20removing%20the%20text%2C%20the%20Pie%20chart%20worked%20perfectly%20as%20see%20in%20the%20caption%20below%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_1-1582493542923.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172858iDBA6AEB61EE4F285%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_1-1582493542923.png%22%20alt%3D%22Abiola1_1-1582493542923.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189763%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Pie%20charts.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189763%22%20slang%3D%22en-US%22%3EHello%2C%20based%20on%20the%20picture%20attached%2C%20you%20need%20to%20have%20numeric%20values%20only%20in%20column%20C%20for%20the%20chart%20to%20work..%20It%20doesn't%20recognize%20alphanumeric..%20%3CBR%20%2F%3E%3CBR%20%2F%3EMoreover%2C%20Pie%20Chart%20is%20limited%20to%20only%20one%20series...%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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...
Highlighted

@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

 

Highlighted

@Abiola1 

 

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

Highlighted

@dougler2020 

 

You're welcome

Related Conversations