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.
- Thereafter, a 2-D chart will be created inside the worksheet.
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.
- Next, press “New” from the “Name Manager” window.
- 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.
Similar Readings
- How to Plot Semi Log Graph in Excel (with Easy Steps)
- Plot Sieve Analysis Graph in Excel (with Quick Steps)
- How to Make an X Y Graph in Excel (With Easy Steps)
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.
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.
