Drag to select a range of cells: the chart below follows the selection and live-redraws. A category column with repeats (like Department) is summed per category. Right-click any cell for the context menu (sort, pin, hide, Chart range). Tick cross-filter to make clicking a bar filter the grid to that category. The toolbar's Create chart button opens a floating dialog.