Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the ... XY (scatter) and bubble charts: These charts are best used to show the relationship between ...

Making a square bubble chart in Microsoft Office Excel is possible if you slightly modify the chart. A bubble chart is a type of scatter chart in which your data points are shown as bubbles.

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 ...

What the data points represent depends on your needs. In this case, the chart compares the number of invoices each month. Figure A This Excel PivotChart shows a YOY comparison of invoices for ...

Reader Tom saw our previously posted Excel Gantt chart template and said he had a better one to offer. Why a spreadsheet? Tom says: I do most of my project planning in MS Project which is great ...