![]() Now, insert the data for your vertical line highlighting the period that achieved the maximum sales. This is how your sales chart will look like: In this example, we will be using a scatter chart to highlight the period in the chart that has the maximum sales. To highlight a point in your chart, you can clearly define its position on the x-axis and create a vertical line for that plot. So, you will have to adjust this line as and when you update the data. ![]() This line is not linked to the data and hence will not change when you change the data. ![]() This will excel add vertical line to chart!Įven though this method is super easy, it comes with its own drawback. STEP 5:To increase the weight of the vertical line, Go to Shape Format > Shape Outline > Weight > 3/4 pt. STEP 4:Draw the line on top of the Chart. STEP 3:Go to Insert > Illustrations > Line. STEP 2:Go to Insert > Line Charts > Line with Markers. STEP 1: Select the data that will be used to create a chart. Follow the steps on how to add a vertical line in Excel graph below: The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |