CODEWITHSUNDEEP
excelexcel-charts
monikapatelIT
monikapatelIT

Reputation: 1007

Pie Chart : with text value in columns

want to draw Pie Chart with following data

  Box   |  Status
  ---------------------------
  Box1  |  Scan
  Box2  |  Index
  Box3  |  None
  Box4  |  None
  Box5  |  Process
  Box6  |  Process
  Box7  |  Scan

Expected result like thisenter image description here

Upvotes: 0

Views: 1139

Answers (1)

a-burge
a-burge

Reputation: 1574

Create a third column with the value of 1 in each cell. Sort on column status. Insert pie chart and change the background colour of areas accordingly while removing line.

If the 'Box' information is not needed, you could create a separate 'Label' table with [Index, check, process, none, scan] and do a countif([status],'Label').

ps. well down with the drawing, you'll never be able to match that authenticity in Excel, unfortunately.

Upvotes: 1

Related Questions