The chart type is a claim about the data. Pick the one that matches what the audience should see:
- Column: compare a few categories, or a few periods.
- Line: change over time, especially with many periods. A line says "this is one thing moving"; columns for twelve months turn into a fence.
- Bar (horizontal): rankings and long category names, which stay readable down the side.
- Pie: parts of a whole, and only with a handful of slices. Past five or six slices nobody can compare the angles; use bars.
- Waterfall: how you got from one total to another, step by step, such as a profit bridge.
Select the chart and click Chart Design > Change Chart Type to switch. The data stays as it is.
Let the question pick the chart.