Hi there,
I am trying to make the following bubble chart with excel:
electrical electronics persistent.png
I want 'job positions' on the Y axis (Entry level, Junior executive, Senior executive, Manager, Senior manager) and the different 'job titles' on the X axis. The size of the bubbles are according to the 'size' of the numbers. So, if you have an Engineer (job title) in Senior Executive position occurs 7 times the bubble will be bigger than an Engineer on entry level which occurs 2 times. I attached a file with example data.
Does anybody know if this is possible with excel? Or do I need to do it with some online program like done in the image?
Bookmarks