# Plotting Row Number Instead of Value in Excel (with Easy Steps)

Written by
Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel sometimes we need to plot row number instead of value for working advantage. This might seem difficult to you if you are not aware of the actual process of doing it. There are various plotting row number instead of value in excel. Today, in this article, I will share with you how to plot row number instead of value in excel.

## 3 Easy Steps of Plotting Row Number Instead of Value in Excel

In the following, I have shared a step-by-step procedure to plot row number instead of value in excel.

Suppose we have a dataset of a company’s Monthly Sales. Now we will plot a graph and then add row numbers instead of values.

### Step 1: Plot Column Chart from Insert Tab

• Above all, select the whole dataset and go to the “Insert” option to choose a desired 2-D Column chart from the list.

• Thereafter, a 2-D chart will be created inside the worksheet.

### Step 2: Use Name Manager Feature from Formula Tab

• Now, simply select the “Formulas” option and choose “Name Manager” from the list.

• Therefore, provide a name and write down the following formula-
`=ROW(Sheet1!\$B\$5:\$B\$12)`
• Gently, press OK.

• As you can see we have finally created a name manager in the list.

### Step 3: Edit Data to Plot Row Number

• In this final step, we will add row numbers to the chart. To do so-
• Select the chart and right-click the mouse button to get options.
• From the options choose “Select Data”.

• Hence, from the new appeared window click “Edit”.

• Now, put the below formula in the “Axis label range” box-
`=Sheet1!rows`

• In summary, you will get the row numbers instead of values in excel without any hesitation.

## Things to Remember

• While putting the axis label range don’t forget to put the name similar to the added name in the name manager list.

## Conclusion

In this article, I have tried to cover all the methods to plot row number instead of value in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

## Related Articles

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF