Need help in creating a bubble chart in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1598567%22%20slang%3D%22en-US%22%3ENeed%20help%20in%20creating%20a%20bubble%20chart%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598567%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3CBR%20%2F%3EHope%20you%20all%20are%20doing%20good!%3CBR%20%2F%3EI%20have%20a%20following%20requirement%20for%20a%20bubble%20chart%20visualization.%3CBR%20%2F%3EHere%20is%20the%20sample%20data%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22192%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3ECategory%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EProject%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EBudget%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EABC%3C%2FTD%3E%3CTD%3EP1%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EDEF%3C%2FTD%3E%3CTD%3EP2%3C%2FTD%3E%3CTD%3E200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EGHI%3C%2FTD%3E%3CTD%3EP3%3C%2FTD%3E%3CTD%3E400%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EABC%3C%2FTD%3E%3CTD%3EP4%3C%2FTD%3E%3CTD%3E350%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EABC%3C%2FTD%3E%3CTD%3EP5%3C%2FTD%3E%3CTD%3E500%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EDEF%3C%2FTD%3E%3CTD%3EP6%3C%2FTD%3E%3CTD%3E150%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EGHI%3C%2FTD%3E%3CTD%3EP7%3C%2FTD%3E%3CTD%3E280%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EGHI%3C%2FTD%3E%3CTD%3EP8%3C%2FTD%3E%3CTD%3E600%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EGHI%3C%2FTD%3E%3CTD%3EP9%3C%2FTD%3E%3CTD%3E360%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EDEF%3C%2FTD%3E%3CTD%3EP10%3C%2FTD%3E%3CTD%3E800%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExpected%20visualization%3A%20X%20axis%3A%20category%2C%20Y%20axis%3A%20Budget%3CBR%20%2F%3EBubble%20represents%20project%20with%20the%20size%20proportional%20to%20budget.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22viz.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213271i6640C9D8E403D790%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22viz.JPG%22%20alt%3D%22viz.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20can%20I%20create%20this%20in%20excel%3F%3CBR%20%2F%3ELooking%20forward%20to%20response.%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1598567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Experts,
Hope you all are doing good!
I have a following requirement for a bubble chart visualization.
Here is the sample data

CategoryProjectBudget
ABCP1100
DEFP2200
GHIP3400
ABCP4350
ABCP5500
DEFP6150
GHIP7280
GHIP8600
GHIP9360
DEFP10800

 

Expected visualization: X axis: category, Y axis: Budget
Bubble represents project with the size proportional to budget.
viz.JPG

How can I create this in excel?
Looking forward to response.
Thanks!

0 Replies