Create a 1-100 chart in Excel using data ranges

A 1-100 chart is a simple way to show numbers from one to one hundred in Excel. This post shows how to create it quickly using Excel fill series and a bar chart.

You can use the auto‑fill handle to generate the numbers, then turn the range into a chart with a few clicks. The exact steps can vary a bit depending on your Excel version, but the core idea stays the same.

Excel online guide: Create a 1‑100 chart with fill series and a bar chart

If you need a quick visual of the numbers from one to one hundred, a 1-100 chart is the simplest solution in Excel. You can generate the numbers automatically and turn them into a bar chart without any coding.

Start by using Excel auto fill numbers to populate a column with the sequence 1, 2, 3… up to 100. Select the filled range, then insert a bar chart to see each value as a bar.

The process works the same in recent versions such as Microsoft 365 Excel, Excel 2019, and Excel for the web, so you don’t need to worry about version differences.

Data range setup: What must be true first

Before you begin, make sure Excel is not in protected view and that the worksheet is not protected, otherwise fill commands will be disabled.

A clear range helps Excel data visualization tools work correctly. If you are on a corporate account, confirm that macros or add‑ins are not blocked by policy.

If you are using Excel on the web, ensure you have edit permissions for the file; a read‑only view will prevent the fill handle from working.

If you convert the filled range into an Excel table (Ctrl+T), the fill handle will automatically extend when you add new rows, and the chart will reference the entire table without manual range updates.

Fill series steps: How to generate numbers and build the chart

Follow these steps to create the numbers and the chart in a few minutes.

1. Select cell A1 and type 1, then click the fill handle (small square at the corner) and drag down while holding the left mouse button to extend the series.
2. Release the mouse and choose Fill Series from the AutoFill options that appear; this tells Excel to continue the numeric sequence.
3. With the column selected, go to the Insert tab and choose 2-D Column from the Charts group to create a bar chart based on the data.
4. Excel will place the chart on the sheet; click the chart to select it and use the Chart Design tab to adjust titles and axis labels if needed.
5. If you want the chart to reflect the full 1-100 chart, make sure the data range includes cell A100; you can resize the selected area manually or let Excel auto‑detect the range.
6. To improve readability, add a chart title like “Numbers 1‑100” and label the vertical axis as “Value”.
7. Finally, save the workbook; the chart will update automatically if you later extend the fill series beyond 100.

Chart design basics: Why it may not work and what to check

Sometimes the chart appears blank, shows wrong values, or the fill series stops early; checking a few items usually fixes it.

• Make sure the fill handle was dragged correctly and the AutoFill option selected; without it Excel treats the numbers as plain text.
• Verify that the cells are formatted as General or Number; a custom format that hides values can cause the chart to be empty.
• Check that the chart’s data source range matches the filled column; a mismatched range can show only part of the sequence.
• Ensure the workbook is not in read‑only mode and that you have edit permission; otherwise Excel won’t update the chart.

After making any corrections, save the file and reopen it to confirm the chart displays the full sequence; a fresh open often resolves display glitches.

Axis labels adjust: A safer way to avoid problems next time

A more robust method is to create an Excel table for the numbers; when you add a new row, the table expands and the chart updates automatically.

You can also define a named range that uses the OFFSET function to grow as you fill, then base the chart on that named range instead of a fixed address.

If you prefer not to use a table, generate the numbers with a simple formula such as =ROW()-ROW($A$1)+1 in each cell; the chart will still reflect the 1-100 chart as long as the formula fills down.

Finally, keep axis labels simple and avoid merging cells; merged cells can interfere with chart selection and cause unexpected behavior.

Another option is to use a sparkline in a cell next to the numbers; it provides a compact visual of the trend without taking up sheet space, and it updates automatically as you fill.

Quick note: the menu names can look a bit different depending on your version of Excel, so don’t be surprised if something shows up in a different spot.

If you found this helpful, feel free to browse the other Microsoft Office guides on the site whenever you need a quick tip or a fix.