Graph Showing Progress by Division By Date

C

covareo

New Member
Joined
Apr 28, 2006
Messages
27
Office Version
  1. 365
Platform
  1. MacOS
I have a sheet of data listed below. The Sheet tracks task due dates and status for 4 verticals - north, south, east, and west. I am trying to show graphs of the following:
  • Percent of projects completed, in progress, and backlog vs entire count for each area (north, south, east, OR west) Doughnut or bar chart?
  • Percent of completed by each due date for each area (north, south, east, OR west) - For example, what percentage of Nov 9th tasks are done for each area individually? (north, south, east, OR west)
  • Percent complete for all areas per due date - for example, for all areas (north, south, east, AND west) what percent of Nov 9th tasks are complete?
  • Percent complete for all areas (north, south, east, AND west) on all tasks
  • Percent Backlog for all areas ((north, south, east, AND west) on all tasks
No real calculation but was getting lost in COUNTIFS and PivotTable complexity and could use some help!

Sheet Data:
Graph.xlsx
ABC
1VerticalWhenStatus
2NorthNov 16thComplete
3NorthNov 16thComplete
4NorthNov 16thComplete
5NorthNov 16thComplete
6NorthNov 16thComplete
7NorthNov 9thComplete
8NorthNov 29thBacklog
9NorthNov 29thBacklog
10NorthNov 29thBacklog
11NorthNov 16thBacklog
12NorthNov 22ndBacklog
13NorthNov 22ndComplete
14NorthNov 16thComplete
15NorthNov 16thComplete
16NorthNov 16thComplete
17NorthNov 16thComplete
18NorthNov 16thComplete
19NorthNov 16thComplete
20NorthNov 16thComplete
21NorthNov 16thComplete
22NorthNov 29thComplete
23NorthNov 29thComplete
24NorthNov 29thComplete
25NorthNov 29thComplete
26NorthNov 29thComplete
27NorthNov 29thComplete
28NorthNov 29thComplete
29NorthNov 29thComplete
30SouthNov 9thComplete
31SouthNov 9thComplete
32SouthNov 9thComplete
33SouthNov 9thComplete
34SouthNov 9thComplete
35SouthNov 9thComplete
36SouthNov 9thComplete
37SouthNov 9thComplete
38SouthNov 9thComplete
39SouthNov 9thComplete
40SouthNov 9thComplete
41SouthNov 9thComplete
42SouthNov 9thComplete
43SouthNov 9thComplete
44SouthNov 9thComplete
45SouthNov 9thComplete
46SouthNov 9thComplete
47SouthNov 9thBacklog
48SouthNov 9thComplete
49SouthNov 9thComplete
50SouthNov 9thIn Progress
51SouthNov 9thIn Progress
52SouthNov 9thBacklog
53SouthNov 9thBacklog
54SouthNov 9thBacklog
55SouthNov 9thBacklog
56SouthNov 9thBacklog
57SouthNov 9thBacklog
58SouthNov 9thBacklog
59SouthNov 9thComplete
60SouthNov 9thComplete
61SouthNov 9thBacklog
62SouthNov 9thBacklog
63SouthNov 9thComplete
64SouthNov 9thComplete
65SouthNov 9thComplete
66SouthDec 31stBacklog
67SouthNov 9thBacklog
68SouthNov 16thBacklog
69SouthNov 16thBacklog
70SouthNov 16thBacklog
71SouthNov 16thBacklog
72SouthNov 16thBacklog
73SouthNov 16thIn Progress
74SouthNov 16thIn Progress
75SouthNov 16thBacklog
76SouthNov 16thIn Progress
77WestDec 6thIn Progress
78WestDec 6thBacklog
79WestDec 6thBacklog
80WestDec 6thBacklog
81WestDec 6thBacklog
82WestDec 6thIn Progress
83WestDec 6thIn Progress
84WestDec 6thComplete
85WestDec 6thComplete
86WestDec 6thComplete
87WestDec 15thBacklog
88WestDec 15thBacklog
89WestDec 15thBacklog
90WestDec 15thBacklog
91WestDec 15thBacklog
92EastNov 9thBacklog
93EastNov 9thBacklog
94EastNov 9thBacklog
95EastNov 9thBacklog
96EastNov 9thIn Progress
97EastNov 9thIn Progress
98EastNov 9thIn Progress
99EastNov 9thBacklog
100EastNov 9thComplete
101EastNov 9thBacklog
102EastNov 9thComplete
103EastNov 9thBacklog
104EastNov 9thComplete
105EastNov 9thBacklog
106EastNov 16thBacklog
107EastNov 16thBacklog
108EastNov 16thBacklog
109EastNov 9thBacklog
110EastNov 9thBacklog
111EastNov 9thBacklog
112EastNov 9thIn Progress
113EastNov 9thBacklog
114EastNov 9thIn Progress
115EastNov 9thIn Progress
Tasks
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
You must log in or register to reply here.

Similar threads

G
  • Solved
Countif has me baffled
2
Replies
11
Views
589
smozgur
smozgur
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
130
Nick Loughton
N
S
  • Solved
Add sheets and rename with direction and current month and year
2
Replies
10
Views
718
Fluff
Fluff
S
  • Solved
Conditional formatting to change font color when value changes, allow sorting
Replies
6
Views
723
Peter_SSs
Peter_SSs
I
  • Solved
Pivot table filter is showing 2 stange dates
Replies
2
Views
323
INN
I

Forum statistics

Threads
1,214,587
Messages
6,120,405
Members
448,958
Latest member
Hat4Life

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top