In Excel: select the data including headers, choose Insert ▸ Recommended Charts and pick a layout; Alt+F1 inserts the default chart on the same sheet, F11 puts it on its own chart sheet.
Arrange the data in adjacent columns with one header row and no total row.
Select the range including headers, e.g. A1:B7.
Choose Insert ▸ Recommended Charts, compare the previews and click OK — or press Alt+F1 for the default chart, F11 for a chart sheet.
If series and categories come out swapped, use Chart Design ▸ Switch Row/Column.
Click Chart Elements (+) to add a title, axis titles and data labels, then replace the placeholder title with a real statement.
In Google Sheets, select the range and choose Insert ▸ Chart, then adjust type and labels in the Chart editor sidebar.
What this does
Creating a chart turns a range of labels and numbers into a picture Excel keeps linked to the data, so the chart updates when the cells change. Recommended Charts reads your selection and proposes sensible types with live previews. The right type follows the data shape: column or bar for categories, line for time series, pie only for a few parts of one whole, scatter when both variables are numeric. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “insert chart title in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected chart change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A1:B7 holds a header row (Month, Sales) plus Jan through Jun with 120, 135, 128, 152, 160, 171. Select A1:B7, choose Insert ▸ Recommended Charts and accept the clustered column chart: six columns rising from 120 to 171, months on the x-axis and the series named Sales from the header. A chart makes comparisons, trends and outliers visible at a glance, which a grid of numbers hides — it is the standard way to present spreadsheet results. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. The short version of “insert chart title in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Selecting values without the header row, so the legend reads Series 1.
- Including a total row, which adds one giant misleading column.
- Choosing a pie chart for many categories or for data that is not parts of one whole.
- Using a line chart for unordered categories where bars compare more honestly.
- Leaving the default "Chart Title" placeholder in the finished chart.
Frequently asked questions
What is the fastest way to create a chart in Excel?
Select the data and press Alt+F1 for the default chart on the same sheet, or F11 to create it on a separate chart sheet.
Which chart type should I pick?
Match the data shape: column or bar for categories, line for time series, pie for a few parts of one whole, scatter for two numeric variables.
How do I make a chart in Google Sheets?
Select the range and choose Insert ▸ Chart; the Chart editor sidebar sets the chart type, series and labels.
Other ways people ask this
People reach this page typing “how to insert a title on a chart in excel”, “insert title to excel chart”, “how to insert a chart title in excel” and “how to insert title in excel chart”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “how to insert a title on a chart in excel”, “insert title to excel chart”, “how to insert a chart title in excel” all point at the one operation explained on this page, which is why they all lead here.