Another way to quickly filter data in an Excel table is to add an Excel data slicer, a series of buttons representing different categories or values within your data.

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

The filter button, which lets you choose which data your chart is displaying, has the same options as the Select Data icon in ...

There are several ways to add text next to a Gantt chart in Excel. Because Gantt charts are made from modified bar charts, the text that normally appears on the chart will not always be relevant ...

To use the timeline to filter both charts at the time, choose a time element from the dropdown in the top-right corner. Figure H shows quarters and I clicked only the Q1 button. Figure H ...