Excel Chart

A Picture Is Worth a Thousand Words. In Excel you can use Charts to deliver a better message of numbers. Let’s say we have the following scenario

A contractor during a construction project is submitting Material samples to the Project Manager (PM) for Approval. The PM asked a log for all submitted and how many materials are approved/pending

See this table

	Discipline	Total	Under Review.	Appr.A & B	Resub. Required B.	Resub. Required C.	Not Sub.
1	Structure	30	0	29	1	0	0
	Architecture	125	0	99	24	2	0
2	ID	256	1	195	58	2	0
3	Landscape + Kitchen+SPA Work-Swimming Pool+Lift works	131	0	127	4	0	0
4	MEP Elect	87	0	80	6	1	0
5	MEP Mech	96	0	88	8	0	0
	Total	725	1	618	101	5

Such a table with more or less intensive data is not much helpful for evaluation. Human loves colors and graphics. So how about this

Now such presentation will improve evaluating the status of Material submittals, where you can easily see there is a a lot of submissions in the ID approved compared to other disciplines.

How to do it:

you can write your own table in Excel or you can copy and paste the above table.
Then select the data you need for the chart including the headers.
in our case selected those cells that inside the Red Rectangle

now right click and select Quick Analysis, and follow the steps shown in the below images.

one more last thing, is to change the style of the chart.
Select the chart that is recently created and follow the below steps

hope this makes things easy for every body.
happy to share this excel file for educational purpose :)
Excel Example