Blog
How to Create a Chart in Excel: Types, Editing, Combo Charts
To create a chart in Excel, select your data including headers, go to Insert > Recommended Charts, pick a chart and click OK. Microsoft's keyboard shortcut list adds two faster routes: Alt+F1 creates a default chart on the same sheet, and F11 puts it on its own chart sheet. Making the chart takes seconds. Making one that reads correctly in a report, with revenue and margin on the right axes, honest scales, and a range that picks up next month's numbers without anyone touching it, is what this guide is about.
How to create a chart in Excel
Microsoft's guide to creating a chart from start to finish lays out the steps:
- Select the data, headers included. Put categories such as months or customers in the first column and numbers in the columns to the right.
- On the Insert tab, click Recommended Charts.
- Click a chart on the Recommended Charts tab to preview it. If none fits, open the All Charts tab.
- Select the chart and click OK.

With the chart selected, three buttons appear at its top right. Chart Elements (the plus sign) turns the title, axis titles, data labels, legend and gridlines on or off. Chart Styles (the brush) changes colors and style. Chart Filters (the funnel) chooses which series and categories appear. The ribbon also gains the Chart Design and Format tabs.
Your data layout decides the chart
Excel usually plots whichever dimension has more items along the horizontal axis. If customers end up on the horizontal axis when you wanted months, click Chart Design > Switch Row/Column. Arranging the source as "categories down the first column, series names across the first row" avoids most of these fixes. Leave total rows out of the selection, or a single total bar will dwarf everything else.
Which chart type to use
Pick the type by what the chart needs to say: compare, show a trend, show a share, or relate two numbers.
| What you want to show | Chart type | Example | Avoid |
|---|---|---|---|
| Comparing items | Column or bar | Revenue by customer, stock by warehouse | Columns with more than 10 items; switch to bar |
| A trend over time | Line | Monthly revenue, weekly shipments | Lines for only three or four points |
| Share of a whole | Pie, 100% stacked column | Revenue by channel | Pies with six or more slices |
| Two values in different units | Combo with secondary axis | Revenue and margin % | Both on one axis |
| Relationship between two numbers | Scatter | Order quantity vs unit price | A line chart in its place |

Column and bar charts need a vertical axis that starts at zero, or small differences look huge. Line charts are about change, so a raised minimum is acceptable, but keep the axis numbers visible.
For long category names like customer names, a bar chart keeps labels readable. Sort the data largest first and you get a ranking, but bar charts draw the first row at the bottom. Double-click the vertical axis and check Categories in reverse order under Format Axis to put the largest at the top.
👉 How to Make a Graph in Excel: Bar, Line and Pie Charts
Edit titles, legends and labels
Quick Layout and Add Chart Element
Chart Design > Quick Layout offers ready combinations of title, legend position, data labels and axis titles. Pick one, then adjust individual pieces with Add Chart Element. Trendlines live in the same menu under Trendline, with Linear, Exponential, Linear Forecast and Moving Average options.

The default title reads "Chart Title." Click it, type = in the formula bar and click a cell; the title is now linked to that cell. Change the cell to "Revenue, Jan to Sep 2026" and the title follows, which saves an edit every month.
Chart Filters
Click the funnel button to see Series and Categories. Uncheck items and click Apply to hide them from the chart without deleting any data, which is faster than reselecting the range when you only want the last six months.

Make axis numbers readable
Large values such as 1,250,000 make long axis labels and squeeze the plot. Double-click the vertical axis, and in Format Axis > Axis Options set Display units to Thousands or Millions. The same pane sets the Bounds (minimum and maximum) and Units (gridline spacing). If Excel picks an awkward maximum like 1,400, fix it at 1,500 so the axis stays stable from month to month.
Size and position
Hold Alt while dragging a chart's edge to snap it to the cell grid, which makes lining up several charts easy. To stop a chart from stretching when you resize rows or columns, open Format Chart Area > Properties and choose Move but don't size with cells or Don't move or size with cells.
Combo charts and a secondary axis
Plot revenue in dollars and margin in percent on one axis and the margin line sits flat on the floor. Microsoft's article on adding a secondary axis recommends a secondary vertical axis when values vary widely between series or when you mix data types such as price and volume.
- Select the chart and click Chart Design > Change Chart Type.
- On the All Charts tab, choose Combo.
- Set revenue to Clustered Column, set margin to Line, and check Secondary Axis for the margin series.
- Click OK. A percentage axis appears on the right.

Always add axis titles to a dual-axis chart. Use Chart Elements > Axis Titles to label the left axis "Revenue ($K)" and the right "Gross margin (%)" so no one reads the line against the wrong scale.
Worked example: a monthly revenue and margin chart
At Ridgeline Manufacturing, the sales operations lead puts a "monthly revenue and gross margin" chart in every leadership report. The sheet has Month in column A (January to September), Revenue in $K in B, and Gross Margin % in C. Until last month, a fresh chart was built every time and restyled by hand, about 30 minutes of work.
Step 1: make the source a table. Selecting A1:C10 and pressing Ctrl+T turns it into a table. A chart built on a table expands automatically when an October row is added. A chart on a plain range needs its range widened through Select Data every month, and when someone forgets, a report goes out with September as the last month.
Step 2: build the combo chart. From the table: Insert > Recommended Charts > All Charts > Combo, revenue as clustered columns, margin as a line on the secondary axis.
Step 3: tidy the elements. The title was linked to cell E1, both axis titles were added, and the legend moved to the bottom. Data labels went on the margin line only, so values like "23.4%" are visible, while revenue bars are read against gridlines. Labels on every series overlap and make the chart harder to read.
Step 4: save it as a template. Right-clicking the chart and choosing Save as Template stores colors, fonts and layout in a .crtx file. Other teams apply it from Change Chart Type > Templates, so every report uses the same chart style.
Step 5: next month. Typing October's numbers in the row under the table added a new bar and point immediately. The 30-minute rebuild became one row of data entry.
When an Excel chart looks wrong
Dates are spaced unevenly. A date axis leaves gaps for days with no data. For business-day data, open Format Axis > Axis Options and choose Text axis.
The line breaks in the middle. There's a blank cell in the source. Under Chart Design > Select Data > Hidden and Empty Cells, choose to show empty cells as Gaps, Zero, or Connect data points with line. Use zero for months with no sales and gaps for months not yet closed.
Data in hidden rows disappears. Charts skip hidden rows and columns by default. In the same Hidden and Empty Cells dialog, check Show data in hidden rows and columns.
The legend says "Series1." The header was left out of the selection. In Select Data, edit the series and point its name at the header cell.
One bar towers over the rest. A total row or column is in the range. Remove it with Chart Filters or from the range.
Differences between Excel versions
Microsoft 365, Excel 2024, 2021 and 2019 for Windows share the same menus. Excel for Mac has Recommended Charts and the Chart Design tab as well. Excel for the web creates charts from the Insert tab and edits titles, legends and data labels; chart templates (.crtx) are saved and applied in desktop Excel. Waterfall, histogram and box-and-whisker charts are built in from Excel 2016 onward.
FAQ
Q. If I paste a chart into PowerPoint, will it update?
A chart copied from Excel and pasted into PowerPoint stays linked to the workbook by default. After changing the numbers in Excel, use Chart Design > Refresh Data in PowerPoint. Paste it as a picture if you want it frozen.
Q. How do I move a chart to its own sheet?
Select it and choose Chart Design > Move Chart > New sheet. To create it on a chart sheet from the start, select the data and press F11.
Q. Can I lock charts to company colors?
Set each series color under Format Data Series > Fill, then save the chart as a template. To change the theme colors for the whole workbook, create custom colors under Page Layout > Colors.
Q. How do I add a target line?
Add a Target column to the table with the same value in every row, include it in the chart, and change only that series to a line. It draws a flat target across the chart.
How inline AI builds the monthly report chart
With the revenue sheet open, you tell inline AI "revenue as columns, margin as a line on a secondary axis, with axis titles and units." inline AI converts the range to a table, builds the combo chart with titles and labels, and places it in the report document, so the monthly chart rebuild disappears from the calendar.
Hand your documents and your company’s work to inline AI.
Keep a file open, say what you need, and AI edits it or drafts a new one. Add the company AI OS and AI runs the rest of the work, ERP included.
Book a demo



