lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I'm creating a bubble charts with 4 columns: Store, Profit/Volume, Volume, Total Revenue. They're in that order so that I can have the x-axis be Profit per Volume, the y-axis be volume, and the size of the bubble be Total Revenue, which seems to be working so far - but I would like to use column A which is the store name to label each bubble, and all I can get is the values to show up as labels.
Second question would be how to have all the bubbles be different colors but I'm looking for that on Google right now.
Second question would be how to have all the bubbles be different colors but I'm looking for that on Google right now.