How to make meaningful graphical presentation out of Staff Register

[questforexcel]

Hi All,

Below is an example of 5 records for my staff records I have to analyse each month. I would have over 1000 records each month. I would need to track the monthly overall staff count for the organization and analyze different charts on it. How can I best present this graphically.

When I try to present this using a line chart, its simple and shows the total. I've only included one manager's name below. In reality I would have more than 10 managers. I would like the data to be easily sliced in a graphical/chart format where I can show the total staff count, even may be have a way to show it by managers and later if possible position type.

I tried using stacked bar chart but that would lead too much of data in one smaller confined chart. Is there a better way to present this?

Thank you,

Name

Location

Date of Joining

Position

Manager

Active/InActive

Jan-22​

Feb-22​

Mar-22​

Apr-22​

May-22​

Jun-22​

Jul-22​

Aug-22​

Sep-22​

Oct-22​

Nov-22​

Dec-22​

Jan-23​

Feb-23​

Tyson

Tokyo

12-Aug-22​

Manager

Tom Stevenson

A

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

Diesel

Singapore

12-Aug-22​

Director

Tom Stevenson

A

0​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

Charlie

Kuala Lumpur

12-Aug-22​

Analyst

Tom Stevenson

A

1​

0​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

Dwayne

Beijing

12-Aug-22​

Sales Rep

Tom Stevenson

I

0​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

1​

0​

 

[awoohaw]

Are there multiple positions in the same location(s)? You probably can do things with maps, sliced by manager.
can you post some more anonymized data regarding names, but realistic locations so folks can play around with things for you?
the xl2bb add in can help greatly, see the link below...

 

[questforexcel]

Yes, there are multiple positions in the same location. Please find attached the sheet in XL2BB format.

I would like it to be displayed by position and reporting manager. I like the idea on the location map. How can we do that in excel?

Is it possible to add an excel slicer for this, but for the slicer to show up on a different page?

Thank you

Dummy File.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Name	Location	Date of Joining	Position	Manager	Active/InActive	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23
3	Tyson	New Jersey	12-Aug-22	Manager	Tom Stevenson	A	1	1	1	1	1	1	1	1	1	1	1	1	1
4	Diesel	Toronto, Canada	12-Aug-22	Director	Tom Stevenson	A	0	1	1	1	1	1	1	1	1	1	1	1	1
5	Charlie	London, UK	12-Aug-22	Analyst	Tom Stevenson	A	1	0	1	1	1	1	1	1	1	1	1	1	1
6	Dwayne	Dubai, UAE	12-Aug-22	Sales Rep	Tom Stevenson	I	0	1	1	1	1	1	1	1	1	1	1	1	1
7	Tom	London, UK	12-Aug-22	Analyst	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
8	Jerry	London, UK	12-Aug-22	Director	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
9	Doodle	London, UK	12-Aug-22	Manager	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
10	Poodle	Toronto, Canada	12-Aug-22	Sales Rep	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
Sheet1

 

[awoohaw]

I'll see what I can do. I enjoy these kinds of exercises.

 

[awoohaw]

Yes, there are multiple positions in the same location. Please find attached the sheet in XL2BB format.

I would like it to be displayed by position and reporting manager. I like the idea on the location map. How can we do that in excel?

Is it possible to add an excel slicer for this, but for the slicer to show up on a different page?

Thank you

Dummy File.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Name	Location	Date of Joining	Position	Manager	Active/InActive	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23
3	Tyson	New Jersey	12-Aug-22	Manager	Tom Stevenson	A	1	1	1	1	1	1	1	1	1	1	1	1	1
4	Diesel	Toronto, Canada	12-Aug-22	Director	Tom Stevenson	A	0	1	1	1	1	1	1	1	1	1	1	1	1
5	Charlie	London, UK	12-Aug-22	Analyst	Tom Stevenson	A	1	0	1	1	1	1	1	1	1	1	1	1	1
6	Dwayne	Dubai, UAE	12-Aug-22	Sales Rep	Tom Stevenson	I	0	1	1	1	1	1	1	1	1	1	1	1	1
7	Tom	London, UK	12-Aug-22	Analyst	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
8	Jerry	London, UK	12-Aug-22	Director	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
9	Doodle	London, UK	12-Aug-22	Manager	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
10	Poodle	Toronto, Canada	12-Aug-22	Sales Rep	Mitchell Johnson	A	0	0	0	0	0	0	0	0	0	0	1	1	1
Sheet1

Just 10? that will make some pretty short columns !


I'll mock some up.

 

[questforexcel]

Just 10? that will make some pretty short columns !


I'll mock some up.

Sorry. Thank you for that. Look forward to your advice and help.