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

Avatar photo
Written by Wasim Akram
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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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.

Insert Column Chart to Plot Row Number Instead of Value

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

Insert Column Chart to Plot Row Number Instead of Value

Read More: How to Create a Chart from Selected Range of Cells in Excel


Step 2: Use Name Manager Feature from Formula Tab

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

Use Name Manager Feature from Formula to plot Row Number Instead of Value

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

Use Name Manager to plot Row Number Instead of Value

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


Similar Readings


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”.

Edit Data to Plot Row Number instead of value

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

Edit Data to Plot Row Number instead of value

  • 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.

Plotting Row Number Instead of Value in Excel

Read More: How to Plot Multiple Lines in One Graph in Excel


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
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo