An ideal graph that summarizes the situation

[asifamanulla]

Excel experts,

I am working on a contractor replacement project and would like to share the numbers with the management. I need help to present the correct excel graph for easy understanding.

What I am trying to say with the graph is - there is a total of 242 contractors on site to be replaced by other vendors. Due to the management decision, we're terminating the contract of a manpower supply company and replacing all their contractors.

Below is the break up of 242;

1. 49 contractors will be insourced and will directly work with our company.
2. 12 contractors have been demobilized (this is because 16 new contractors have joined)
3. 69 contractors will finish contractors will end the contract on Dec 31st and will not be replaced.
3. 124 contractors will be replaced by other vendors.
3. Out of 124, 16 contractors have been mobilized
4. Out of 124 replacements to be identified (point. 2), 93 are under mobilization.
5. Out of 124, 15 replacements are yet to be identified.

I would like to show a graph that explains these numbers. I have attached a graph, which is kind of confusing. Please, could you suggest a graph that is ideal?

Regards,
Asif

[asifamanulla]

I have tried to attach the file here.

[MrShorty]

It seems like more of a generic "what kind of chart should I use?" rather than the Excel specific "how do I create [chart type] in excel?" We are better at the latter question than the former question.

I'm not sure what is confusing about the simple column chart you show in your example. It seems fairly clear and straightforward to me. The main thing I don't get from the column chart is that many of the categories are really "subsets" of other categories.

In the spirit of brainstorming ideas, have you tried a stacked column chart? That could be easily set up to show total contractors as well as how different types of contractors are "subsets" of other categories.