Sudipta Chandra Sarker
In this article, we will show you how to add vertical line to histogram in Excel. Basically, a histogram is a column chart that displays how frequently a variable occurs within a given range. Moreover, it is a common tool for data analysis in the corporate world. Often you might need to add vertical line to the histogram to indicate some information. You can easily make this chart in Excel. So, without any delay, let’s start the discussion.
Download Practice Workbook
To practice by yourself, download the following workbook.
What Is Histogram in Excel?
A histogram shows the frequency of data in different intervals within the data range. It is a graph with a series of rectangular bars. The number and height of the bars are proportional to the number of different ranges called bins and to the frequency of data within those bins. For example, if you want to create a histogram from the result scores of the students in a class, you can assess the performance of the class at a glance. Because you will know how many students failed, how many of them got good grades, etc. the moment you look at the histogram. It can be very useful during your presentations.
Step-by-Step Procedures to Add Vertical Line to Histogram in Excel
To demonstrate the method we will use the dataset of a class. The dataset contains information on the name of the students and their obtaining marks in the English examination. Let’s follow the steps below to know how to add a vertical line to the histogram in Excel.
STEP 1: Make Dataset Ready
- Firstly, we need to make the dataset ready.
- Here, we have taken the following dataset.
- In the B column, there is information about the student’s name.
- And, their marks are given in the CÂ column.
Read More: How to Make a Histogram in Excel Using Data Analysis
STEP 2: Insert Histogram Chart
- Secondly, we will insert the histogram chart.
- To do so, select the C5:C15 range to select the marks.
- After selection, go to the Insert tab.
- Then, from the Charts group section, you have to select the Insert Statistic Chart and then select Histogram.
- Instantly, the histogram will appear.
- After that, we have to modify the horizontal axis to beautify the histogram.
Read More: How to Plot Histogram in Excel (5 Easy Ways)
STEP 3: Format Axis of Histogram
- In the following step, double-click on any rectangle of the histogram.
- As a result, a new window named Format Data Point will appear on the right side of the Excel Sheet.
- Now, increase the gap width according to your preference.
- Here, we have made the gap width 15%.
- Again, double-click on the horizontal axis or bins values.
- Here, bins indicate the range of the rectangle of the histogram.
- After that, from the Axis Options, change the Bin width according to your choice.
- Here, the Bin width represents the width of the rectangle.
- So, we have made the width 10.
- Also, you may change the Overflow bin and Underflow bin.
- Here, the Overflow bin represents the maximum limit of the bin and the Underflow bin indicates the minimum limit of the bin.
Read More: How to Create a Bin Range in Excel (3 Easy Methods)
Similar Readings
- How to Make a Stacked Histogram in Excel (3 Easy Methods)
- What Is Bin Range in Excel Histogram? (Uses & Applications)
- How to Change Bin Range in Excel Histogram (with Quick Steps)
STEP 4: Insert Title of Histogram
- In the following step, we will insert the title of the histogram.
- To do so, double-click on the Chart Title.
- After that, type the title.
- Here, we have given the title Histogram.
Read More: How to Make a Histogram in Excel with Two Sets of Data (4 Ways)
STEP 5: Add Vertical Line to Histogram
- In this step, we will add a vertical line to the histogram.
- To insert, click on the Insert tab.
- After that, select Illustrations >> Shapes >> Line to insert the vertical line.
- Instantly, you will see that your mouse cursor will be changed.
- Then, click close to the point where you want to insert the line.
- In our case, we add the line between 2 rectangles of the histogram.
- After that, hold down your SHIFT key on the keyboard.
- Then, click where you want your line to begin and drag it down to add length to your line.
- As a result, the line will appear on your graph.
Read More: How to Create Histogram in Excel Using VBA (With Easy Steps)
STEP 6: Modify Vertical Line
- But, the vertical line is not clearly visible clearly.
- Therefore, we need to increase its width and color.
- To do so, double-click on the vertical line.
- This will take you to the Shape Format tab.
- Then, click on the following icon to shape the line.
- Instantly, a wizard will come out.
- From the wizard, we have selected a yellow wide-line option.
- Here, you can select as per your preference.
- As a result, our modified vertical line is now visible.
- Moreover, you can move your vertical line in your histogram.
- To do so, click on the line and drag it left and right as per your wish.
Read More: Difference Between Excel Histogram and Bar Graph
Final Output
- Finally, we have been able to add a vertical line in the histogram.
- We have placed our line in the range of 66 to 76.
Read More: How to Make Histogram Using Analysis ToolPak (with Easy Steps)
Things To Remember
- For other types of charts, it is easy to add vertical lines. You can insert vertical lines by using Excel Shapes, applying Combo Chart and Chart Trendline.
- But, for histograms, you can insert vertical lines just only using Excel Shapes.
- For other charts, you can also insert dynamic vertical lines. Unfortunately, it is not possible to histogram.
Conclusion
In this article, we have demonstrated how to add vertical line to histogram. There is a practice workbook at the beginning of the article. Go ahead and give it a try. To read similar articles, check out the ExcelDemy website. Last but not least, please use the comment section below to post any questions or make any suggestions you might have.
