Forum Discussion
Chart for Percentage Complete
Okay, in my assumption it looks like this
In Y1 and Z1 put the titles for your labels, in Y2 number of incomplete items
=COUNTIF(W:W, "<16")
in Z2 number of completed ones (assuming you ahve any infor in A columns for your items)
=COUNTA(A:A)-1-Y2
Above could be at any place of your workbook. Select Y1:Z2, in Ribbon Insert Pier Chart (or which one your prefer), stay on chart and in Ribbon->Design->Add Chart Element add/remove elements you wish, after that format Legend and add %, value, category name.
File is attached.
Taryn, let me clarify.
You have 549 rows (or so) from which let say 200 have status "complete" (shows 16 in W) and other 349 are incomplete (less than 16 in W). You'd like to have a pie which shows in % 200/549 as completed part and 349/549 as incompleted part, correct?
Okay, in my assumption it looks like this
In Y1 and Z1 put the titles for your labels, in Y2 number of incomplete items
=COUNTIF(W:W, "<16")
in Z2 number of completed ones (assuming you ahve any infor in A columns for your items)
=COUNTA(A:A)-1-Y2
Above could be at any place of your workbook. Select Y1:Z2, in Ribbon Insert Pier Chart (or which one your prefer), stay on chart and in Ribbon->Design->Add Chart Element add/remove elements you wish, after that format Legend and add %, value, category name.
File is attached.
This is exactly what I needed and was looking for!!! I appreciate your help and time on this :)
