Attached is a spreadsheet w/ dummy data, representative of a real data set I'm working with.
I'm not great w/ excel charts and am trying to put together a scatter chart where the X-axis is "Size" and the Y-axis is "Earnings per Hour", but also have the dots different colors and sizes depending on the underlying data, as a way to show which assets are most important (those being the largest assets with the highest earnings per hour).
I was thinking to have the highest earning assets colored green, and the lowest light blue, and the size of the dot depending on the size of the asset, so the larger the project is, the bigger the dot on the chart will be.
Appreciate the help. Thanks!
Bookmarks