Siam Hasan Khan
Creating charts is one of the main purposes for which you use Excel. The different kinds of charts give us a visual representation of the data we are working on. In this article, I will show you how to create a chart from the selected range of cells in excel in 4 efficient ways.
Download Practice Workbook
Get this sample file and try the methods by yourself.
4 Efficient Ways to Create a Chart from Selected Range of Cells in Excel
To describe the process, we have prepared a dataset. It shows the information of the Sales Report in the months of January, February and March for 8 types of electric products.
Now, we will create a chart out of this dataset. Let’s check the process below.
1. Create a Chart from Selected Cell Range Using an Excel Table
Normally while creating a chart you select the whole range of cells of your table. Before creating any chart, you create a table from which you can create different kinds of charts you want. In this process creating a chart is very easy using an Excel Table. Let’s see how it works.
- In the beginning, go to the Home to and select Format as Table under the Styles group.
- After making a table, select all the cells of your table while pressing the left button of your mouse.
- Following, press on to the Insert tab and select Bar Chart from the Charts section.
- Then, select any chart you want.
- You can also insert the charts by selecting the range of cells and then clicking the right button of your mouse to select the Quick Analysis option.
- After clicking the Quick Analysis option, you will see the Charts section.
- Here, you can select any charts you want.
- Finally, you will get to see the chart in your worksheet by applying any two of these methods.
Read More: How to Make a Graph from a Table in Excel (5 Suitable Ways)
2. Apply OFFSET Function to Create Chart from Selected Cell Range
If you didn’t create a table but want to create a chart for various data, you can create Name Ranges and apply the OFFSET function further to run the process. For this follow the steps below:
- First, select the Formulas tab and then in the Defined Name section select the Name Manager.
- Afterward, you will find a new dialogue box.
- Now, to create a new Name Range, select the New option.
- Following, in the New Name dialogue box, type TableForChart in the Name box.
- Along with it, insert this formula in the Refers to box.
=OFFSET!$B$4:$E$12
Here, we applied the OFFSET function to facilitate modification after creating the chart. Because of this, whenever you insert or remove any data, the chart will automatically change accordingly.
- After this, press OK.
- Now, you will find this Name Range in the Name Box.
- After selecting the Name Range from the Name Box you will see that all the cells of this Name Range are selected.
- Lastly, follow the same steps stated earlier to create any chart you want.
Read More: Plotting Row Number Instead of Value in Excel (with Easy Steps)
Similar Readings
- How to Plot Semi Log Graph in Excel (with Easy Steps)
- Plot Sieve Analysis Graph in Excel (with Quick Steps)
3. Modify Data Source to Create a Chart from Selected Range of Cells
With the help of Name Range, you can even create new charts in an existing chart. Let’s see the process below:
- First, select the existing chart.
- Then, click on the Design tab to select the Select Data option under the Data section.
- Now, in the Horizontal (Category) Axis Labels, select the categories you want in the chart.
- Then, press OK.
- Lastly, you will see a new chart in your worksheet which is different from the previous one.
Read More: How to Plot Graph in Excel with Multiple Y Axis (3 Handy Ways)
4. Select Specific Range of Cells for Creating a Chart in Excel
Suppose you don’t need some of the product information in your chart. The question arises what can you do? The answer is very simple. In this case, don’t select the information about those products which you don’t want to show in your chart. In my case, my table consists of 8 product names. I want to create a chat with 5 products. So, let’s follow the process below for this type of situation.
- First, select all the relevant information for the 5 products in cell ranges B4:E7 and B11:E12. The information on the 3 products will not be selected.
- Next, go to the Insert tab and click on Recommended Charts.
- Following, select any type of chart from the All Charts section.
- Finally, press OK.
- That’s it, you will see that only the selected product information will be shown in the chart.
Things to Remember
- Apply keyboard shortcut Ctrl + T for creating a table from your dataset.
- When you add new data to the worksheet, it will automatically update the chart. Also, deleting any data will not entirely remove the data points from the chart.
- Make sure there is no blank cell in the dataset.
Conclusion
I hope after reading this article you will surely learn the process of how to create a chart from the selected range of cells in excel in 4 efficient ways. Follow ExcelDemy for more useful articles like this one. If you have any queries, place them in the comment box below.
Very good, it help me a lot.