Showing Pivot Chart Value as 100%

[Sam Summers]

Hi,

I have tried to solve this but i am completely new to Pivot Tables/Charts?

Basically i have two totals:

Value 1 which is the number of working Employees
and Value 2 which is the total number of Employees

Both are subject to change but my main problem is that Value 2 (Total of Employees) i want to display as 100% in a chart and Value 1 is the percentage of employees utilized.
I have the calculation working fine (Value 1/Value 2).
But if for example i have 35 employees as Value 2, how do i make that show as 100% in the chart?
I get things like 35 or 3500%?
I have played about endlessly changing values etc but just cant get it and cant find anything so far that helps?
It shouldnt be too hard?

Thank you in advance

 

[Mile-O]

If value 2 is 35, what's value 1?

 

[Sam Summers]

They both change weekly.

so Value 2 (35) may be 36 next week and Value 1 is 3 and then could be 8?

Just depends how many employees we have employed in total but not utilized.

In fact a better way for me to describe this is:

Value 2 is Total Employees on our books (subject to change as we employ or someone resigns)

And Value 1 is the number of employees actually deployed on a project (i.e. not off or on leave)

 

[Sam Summers]

Actually in hindsight i think i have found what i was doing wrong?

I was including the say 35 (Total) employees as well as the percentage for example 4% of the 35 in the Pivot chart which will not work!

All i need to do is only include the % of employees that are currently utilized and set the Axis to 100% and that will read correctly.

UPDATE:

That doesn't work as the % inserted then becomes 100%?!

There must be away to set the scale or something?
How do i represent the percentage as the percentage of Total employees?