This formula will enter 1 in the cell of the supporting column when it finds the max value in the Sales column.Ģ: Select the table and insert a Combo Chart: Select the entire table, including the supporting column and insert a combo chart. = IF( I have used the Excel Tables, I get structured data to use in the formula. And insert this formula to identify the max value. To insert a vertical line on the max point, we need a supporting column that identifies the max value. I want to have a line chart that shows the sales in different months on the timeline and mark the maximum value by adding a vertical line.ġ: Add a support column to Identify the max number. The data is stored in an Excel Table so that our chart can be dynamic. Here I have a record of sales in different months of a year. So, let's start: Example: Add A Vertical Line to a Line Chart to Mark Max Value And in this article, we will learn how to insert a dynamic vertical line in the chart that changes its location. We would like to add vertical lines dynamically to mark a certain data point, say the max value.
We can draw a vertical line on the chart manually but that's just not smart.
And while working with line charts, we get the need to add a vertical line to mark something (let's say a data point). The line charts are fantastic tools in Excel to visualize records over time.
