I want to make a scatter bubble chart with vertical axis labels that display ranked levels and a horizontal axis that displays the category to be ranked. The size of the bubbles in the chart should correspond to the numbers in the dataset, and there would be multiple bubbles above each category on the horizontal axis. (See attached spreadsheet)Skill Ranking Data.xlsx
How do I tell excel to use text categories for both the vertical and horizontal axes? And how do I get the bubbles in the scatter plot to correspond in size to the numbers within the dataset?
(Please note: I don't have Power View)
Thanks for any help!
Bookmarks