Charts and sparklines are powerful data visualization tools in Excel. Here’s a ... Pie charts are ideally suited to showing portions of a whole. XY (scatter) and bubble charts: These charts ...

Pie charts are used to show percentages of the whole, and Line charts excel with data trends ... avoid the following designs altogether: Radar, Bubble, XY/Scatter, Treemap, Waterfall, and Box ...

However, Excel has no specific tools for adding individual data labels to each bubble. You will need to add each data label separately. For example, say you have just created the following bubble ...