Percentage Variance Graphs

[Bobo6782]

Hi there. New to the forum and come looking for advice and help!!

I am looking to graphically represent the % movement from a baseline target on a graph.

I will give an example of what i am looking to do.

I have 10 departments. Each has a split of Permanent and Non Permanent staff. This gives a total of say 1000 people per department. Each department has a separate unique target of the % of non permanent staff they want to hit.

I am looking to show in a graph the movement from the base to their position now. Ideally i would like to show the movement in overall numbers but also in the % of non permanent staff change in that time period.

Any help would be gratefully appreciated!!

 

[Bobo6782]

Hi there. New to the forum and come looking for advice and help!!

I am looking to graphically represent the % movement from a baseline target on a graph.

I will give an example of what i am looking to do.

I have 10 departments. Each has a split of Permanent and Non Permanent staff. This gives a total of say 1000 people per department. Each department has a separate unique target of the % of non permanent staff they want to hit.

I am looking to show in a graph the movement from the base to their position now. Ideally i would like to show the movement in overall numbers but also in the % of non permanent staff change in that time period.

Any help would be gratefully appreciated!!

Apologies should have stated i am using Excel 2010.