• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combo Chart

Sarravana Kumar

New Member
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
 

Attachments

  • Map EE Salary to Mkt.xlsx
    83.1 KB · Views: 4
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…
 

Attachments

  • Chandoo53574Map EE Salary to Mkt.xlsx
    88.2 KB · Views: 4
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
)
 

Attachments

  • Chandoo53574Map EE Salary to Mkt.xlsx
    34.9 KB · Views: 5
Back
Top