Forum Discussion
Pratz203
Aug 19, 2020Copper Contributor
Need help in creating a bubble chart in excel
Hi Experts,
Hope you all are doing good!
I have a following requirement for a bubble chart visualization.
Here is the sample data
| Category | Project | Budget | 
| ABC | P1 | 100 | 
| DEF | P2 | 200 | 
| GHI | P3 | 400 | 
| ABC | P4 | 350 | 
| ABC | P5 | 500 | 
| DEF | P6 | 150 | 
| GHI | P7 | 280 | 
| GHI | P8 | 600 | 
| GHI | P9 | 360 | 
| DEF | P10 | 800 | 
Expected visualization: X axis: category, Y axis: Budget
Bubble represents project with the size proportional to budget.
How can I create this in excel?
Looking forward to response.
Thanks!
No RepliesBe the first to reply