How to make a chart in Excel beautiful in 2026: step-by-step instructions

The labor market is in a fever due to the development of neural networks, digital avatars are undergoing interviews, AI agents maintain client databases and answer letters. Meanwhile, the number of Microsoft 365 commercial users alone topped 400 million in early 2025. Who needs an Excel office legend now, when all the calculations and tables can be generated in ChatGPT, and the presentation can be drawn in Gamma and analogues? 

Still, it’s too early to write him off. According to KORUS Consulting, the majority of Russian companies in 2025 build business planning through Excel, and a 2025 Vena Solutions study said that 89% of financial analysts surveyed still rely on Excel for calculations, data analysis and income planning. Diagrams are also relevant, with the help of them it is easy to turn a table with thousands of rows into a clear conclusion: how much profit exceeded investments, how the budget was distributed among departments, why sales grew in one region and fell in another. In this article we will show you how to build a chart in Excel using a data table and how to design it to match the style of the document. 

Why do we need charts in Excel and what types exist?

Charts are used to show what numbers say. For example, when a table with quarterly sales takes up half a page, and the manager needs to understand where the drawdown is, or when the marketing department compares the effectiveness of campaigns: this is immediately visible on the graph. Another example is financial reports; when creating a chart of expenses, it is easy to see where the budget is flowing. In HR analytics, it can be used to conveniently compare staff turnover across departments, and in production, it can be used to track defect dynamics or line workload. As a result, in a second you can understand what is happening in the business, as well as highlight patterns that are difficult to notice in rows and columns. 

Charts can be created in different tools, but if the table was created in Excel, it is logical to create them there. 

Basic types of charts in Excel

• Column and bar charts—show category comparisons, such as revenue by region or profit by quarter.

• Line charts are suitable for tracking dynamics over time when it is important to see the trend.

• Circular - display fractions of the whole, convenient for reports on 3-5 categories (no longer needed, it will be hard to see).

• Combined - combines several types (for example, columns and a line) and helps to show relationships.

• Dot and bubble are useful when you need to show the relationship between variables or the amount of data.

Other types (hierarchical, cascading, funnel-shaped, statistical) are less common, mainly in analytics and BI reports.

Excel offers dozens of visualization options and allows you to customize each one to suit your report style. And on the Microsoft website there are free diagram templates. 

Basics of working with charts in Excel

Excel works according to simple logic. First, you select a range of data, then select the Insert tab → Charts and visualization type. The program itself determines where the signatures are and where the numerical values ​​are, and builds a graph based on the selected rows and columns. Excel also offers a quick option - press Alt + F1 and the chart will appear instantly, although it's not certain that this will be the best type for your data. When the data in the table changes, the diagram is updated automatically; it is “linked” to the source.

Each chart consists of elements: title, plotting area, axes, legend, and labels. All these parts can be added, removed or edited, including after construction, through the Diagram Designer tab. 

If you want to get a visual result without manual settings, use the Recommended Charts function: Excel itself will suggest options that best suit the table structure. 

Excel can not only build charts, but also link them to other documents. For example, you can make a graph in Excel and insert it into Word as a linked one: in this case, the document does not store the data itself, but a link to the source Excel file. If the data in the table changes, the chart will update automatically. 

Procedure:

1. After constructing a chart in Excel, select it and click Cut on the Home tab → Clipboard;

2. In Word, select the insertion location and click Insert;

3. Make sure that the Insert Options button appears next to the chart - this means that the connection with Excel is established;

4. When you open a Word document, click Yes to update the data from Excel.

This feature helps keep reports up to date and saves hours of manual work.

Preparing data before building a chart

Excel is not AI; it cannot think up information or remove blank lines or duplicate cells. Therefore, you first need to clean the table and put it in order. 

1.  Arrange the data on the sheet. For most charts (bar, line, scatter), regular rows and columns will do. Excel itself will determine what is best to take as the X axis and what to use as values.

• Column and Line Charts: Data can be arranged in both rows and columns.

• Circular: require one series of data and one category, with the help of them it is convenient to show shares or percentages (sales by region).

• Ring: Allows multiple series of data, each forming a separate ring. With them, for example, you can compare the results of different periods. 

• XY-spot and bubble: the first column is the X-axis values, the second is the Y-axis, the third is the bubble size.

• Stock: three columns or rows - high, low and close (or date if used as a signature).

1. Check the table structure. The first line should contain headings, the cells should contain only values. Remove empty lines, duplicate signatures, and random characters. If the data is from different sources, bring them to a single format - Excel is sensitive to spaces and extra characters.

2. Minimize noise. Leave only what you really need to visualize. The shorter and cleaner the table, the faster you will get a readable chart.

Tip: Select one cell in the range and Excel will select the adjacent data and build a chart. Non-contiguous areas can be selected with the Ctrl key if they form a rectangle.

How to make a diagram

When the table is ready, all that remains is to select the necessary cells and build a diagram. Excel does everything intuitively, but the order is important.

1. Select data. Click the first cell in the range and drag the cursor to the last one, or hold Shift and use the arrow keys. To select the entire sheet, press Ctrl + A. Non-contiguous areas can be selected with Ctrl or Shift + F8.

2. Create a diagram. Go to the Insert → Charts tab, select a visualization type and subtype. If you're not sure, open Recommended.

3. Location. By default, the chart is inserted directly into the worksheet. To move it separately, open the Chart Builder tab → Move Chart and select New Sheet.

If the program has mixed up rows and columns, you can correct it through the Chart Designer → Select data → make changes.

Formatting a chart

When the diagram is ready, the fun part begins—the design.

1. If a report is expected in 10 minutes, use ready-made layouts and styles. On the Chart Designer tab, select Express Layout to instantly apply one of the preset layout templates. To change the color scheme and design, in the Chart Styles group, select a style that suits you, or click the arrow to see all the options.

2. When you want beauty, configure the elements manually. Go to the Format tab, select the desired chart element (title, axis, legend, labels) and click Format Selection. You can set the fill color, outline, font, or apply the WordArt effect - suddenly you miss shadows and glows. 

1. Add meaningful details. To make the diagram readable:

• add a title and axis labels;

• include data labels if you need to show exact values;

• customize the legend;

• If necessary, turn grid lines on or off for easier viewing.

1. Change the size and position. After construction, the diagram can be moved to any place on the sheet with the mouse. The size can be adjusted with markers along the edges or manually through the Format → Size tab. 

2. Save. If it turns out beautifully, don’t lose the result. Right-click on the chart and select Save as Template. Now in your next project you can apply this style in a couple of clicks.

If there is not enough space in the report, but you need to show a trend, use sparklines. These are mini-graphs that are placed directly in the cells next to the numbers and show the trend: growth, decline, fluctuations. They do not overload the table, but they instantly give an idea of ​​the dynamics.

Adding sparklines is easy:

1. Select the cell or range where you want to place them.

2. Go to the Insert → Sparklines tab and select a type - Graph, Histogram or Win/Loss.

3. Specify the range of data for which the graph will be plotted and click OK.

The color of the lines, maximum and minimum points can be adjusted in the Sparkline tab.

Tip: Sparklines work great in pivot tables and financial reports where there is no room for a large chart. 

In general, if you need to quickly visualize data, Excel is quite sufficient. And if you want presentations that sell without a speaker, or an annual report that will attract new clients and investors, just fill out the brief.