OmniDocHow to Make a Chart from Spreadsheet Data, Step by Step
Learn how to make a chart from spreadsheet data step by step: select the right cells, insert a chart, then adjust the title, labels and type.
If you have a column of numbers and want to show a trend or a comparison, a chart can make the pattern obvious in seconds. The problem is that many beginners skip the setup. They pick a chart, get bars for the wrong rows or a legend that says nothing, and then spend more time fixing the chart than they would have spent preparing the data.
This guide covers the basic workflow for making a chart in a spreadsheet program: select the data, insert a chart, and adjust it so it reads clearly. You do not need any special skills. You only need a spreadsheet file with at least two columns, such as a monthly sales table with twelve rows.
By the end, you will have a finished chart, you will know which chart type fits your data, and you will have a short checklist to run before you share the result.
How do you make a chart from spreadsheet data? The short answer
Select the cells that contain your labels and values, insert a chart from the charts options, then add a title and clean up the labels so the chart stands on its own.
| Your situation | What to do | Why |
|---|---|---|
| Comparing amounts across categories | Use a column or bar chart | Readers compare bar lengths and heights more accurately than slices or angles. |
| Showing change over time | Use a line chart with dates in the left column | A line makes direction and trend visible at a glance. |
| Showing parts of one whole | Use a pie chart with only 2 to 5 slices | Many slices become hard to tell apart. |
| Mixing two scales, such as sales and percentages | Use two charts or a combination chart | A single axis can make the smaller series look flat. |
| Data includes totals or blank rows | Clean the range before selecting it | Totals and blanks get plotted as extra categories or gaps. |
Before you start: check the data layout
Spend two minutes on the table before you insert anything. The chart is only as accurate as the cells it reads.
- Put headers in the top row and labels in the left column. The program uses this layout to guess which cells are series names and which are categories. A misplaced header often shows up as a series named "1" or "2."
- Make sure numbers are stored as numbers. A value that looks like a number but is stored as text may plot as zero or be skipped.
- Remove total rows that sit inside the data range. A total row gets plotted as one more category and makes the scale misleading.
- Decide the one message the chart should carry. A sentence such as "sales rose in the second half of the year" tells you the chart type and gives you a title.
- Plan the final size. If the chart will go into a Word file or a PDF, size it at the place where it will appear. Text that looks fine on a wide screen may be unreadable on a printed page.
Making a chart from a monthly sales table, step by step
Follow these steps with a table that has months in the left column and sales figures in the next column.
- Open the spreadsheet file and find your table. Locate the header row and the label column so you know exactly what you are selecting.
- Select the cells. Drag from the top-left label cell, which is usually the header cell, to the bottom-right value cell. Include the headers so the series receives its name. Leave out empty columns.
- Open the charts options. Look for the chart group on the ribbon or in the insert menu. Hovering over a chart type usually shows its name.
- Choose a chart type. For monthly sales, a column chart compares the months against each other, while a line chart shows the overall trend. Pick the one that matches your message.
- Check the preview. Count the bars or points against your rows, and confirm the series name looks right. If something is off, undo the chart and fix the selection before inserting again.
- Add a chart title. Name what the chart shows and the period it covers, for example "Monthly sales, January to December." A descriptive title lets readers understand the chart without reading the surrounding text.
- Label the axes and check the legend. Add axis titles with units, such as "Sales (USD)" and "Month." Keep the legend only when the chart has two or more series. A single series does not need one.
- Move and resize the chart. Place it beside the table or on its own sheet, then adjust its size so that every label fits without overlapping.
Check the result
Before you share the chart, run through this list. It takes less time than explaining a wrong number later.
| Check | How to see it | If it's wrong |
|---|---|---|
| Every row appears | Count bars or points against your table | Reselect the range. Look for hidden rows, blank cells or a total row inside the selection. |
| Values match the source | Hover over a bar or point and compare it with the cell | Convert text-formatted numbers to real numbers, then refresh the chart. |
| The axis starts at a sensible value | Read the lowest value on the vertical axis | For column charts, a baseline above zero exaggerates small differences. Set the minimum to zero. |
| Labels are readable at final size | View the chart at the size you will use | Shorten category names, widen the chart or rotate the labels. |
| The chart updates with the data | Change one value in the table and watch the chart | If it does not change, the chart may point to a copy of the data. Reselect the source cells. |
If the labels or headings are in another language, you can translate the spreadsheet file before building the chart. OmniDoc translates Excel (.xlsx) files on omnidoc.top and keeps the original layout. Afterward, open the translated file, check that the chart still points to the right cells, and compare translated labels against the source. Machine translation can misread short terms such as abbreviations or product codes, so review anything that matters before you share it.
❓ FAQ
1. Can I change the chart type after I insert it?
Yes. Select the chart, open the chart type options, and choose a different type. Your data stays the same, so you can test two or three types and keep the one that makes your message clearest.
2. How do I chart data from two separate parts of a sheet?
Select the first range, then hold the Ctrl key (Command on a Mac) while you select the second range. Make sure both ranges have the same number of rows, or the series will not line up.
3. Should I use a 3D chart?
Usually not. Tilted 3D shapes distort the height of bars and slices, so the values are harder to read. A flat 2D chart shows the same data more accurately.
📝 Summary
Making a chart comes down to three things: select clean data with headers, insert a chart type that fits your message, and adjust the title, axes and labels so the chart reads on its own. Run the short check before you share it, and your chart will show exactly what the table shows.
