Combo Chart

[Sarravana Kumar]

Hi all,

I am trying to map employee data to market ranges based on their job profile using combo chart, went through some videos in youtube.

I am probably overlooking something & need this help.

PFA the data.

PS: This is to begin with, I tried Pivots, connecting data as I have a huge dataset (Say 1800 jobs / 50000 Employees) and trying to make it a interactive dashboard.

TIA

Best,
SK

 

[p45cal]

Something like the attached?
It's some time since I used charts in Excel, there may be better chart types to use in Excel now, depending on your version…

 

[Sarravana Kumar]

Hi @p45cal ,

Thank you, may be the output that I indicated was misleading.

Hi all: I am looking for something like the below youtube video. (Attaching the sample data file again).

Excel for HR: Salary Structure Floating Bar Chart with Employee Data - YouTube

 

[p45cal]

In the attached, Sheet1 contains what I think you want, using (more or less) the methods in the video.
Sheet1 (2) contains a variant which addresses the visibility of the grid lines (listen to the commentary at 2 mins 19 secs into the video at

)