# How To Make A Number Line In Excel

### If you forget which button to click just hover over the options.

**How to make a number line in excel**.
From the menu bar at the top click on the format menu and select text box.
Enter 1 in cell a2.
In the editing group click on the fill drop down.
Simply enter the number of values necessary to establish the pattern then activate autofill to complete the number of values you require.

Automatically number values in a sequence in excel 2010 this is the perfect solution if you are inputting sequential values that follow a pattern. From the drop down select series. Copy and paste the box. I want to make a number line in excel 2007 that takes a number from a previous calculation and plots it on a one axis numbe line.

How to make a line chart. Go to the home tab. Using excel to make a number line. Here are the steps to use fill series to number rows in excel.

Use the row function to number rows. Excel will tell you which one is which. Specify the stop value. In the charts group click the insert line or area chart button.

For example the number 186 is calculated and i want it plotted on a line with one end at 163 and the other at 255. Discover answers on how to create a number line in microsoft excel 2007. For example rowa1 returns the number 1. Post you answers or question onmicrosoft excel viewer qa.

Drag the fill handle across the range that you want to fill. In the series dialog box select columns in the series in options. The row function returns the number of the row that you reference. Hover your mouse over the box until the cursor shows four arrows and drag the box into position on its vertical line.

Click anywhere on the diagonal lines but not on one of the circles to turn the border into a series of dots. Change the number in the copied box to the next one in your sequence and position it on its vertical line. Then open the insert tab in the ribbon.