(Note, you will set this vertical axis maximum as detailed below.)į) Now lets make the columns look more like lines by changing some of their formatting. This is 20% above the real data because I want the vertical lines to go above the data and reach the maximum vertical position of the vertical axis. You will see that I have added a data point for each day at a value of 12. It is dynamic and can be controlled with formulas and it will move and adjust as you add data points.Ī) Add an additional column of data that will create an additional line series in your Excel Chart. This is my recommended way to quickly and easily add as many vertical lines as you want to your Excel Line Chart. So you will have to constantly adjust the line as the chart adjusts. This is really the easiest way to add a line, HOWEVER, the line is not very dynamic and may get “OUT OF LINE” if you will when you add new data points to your line chart. If you found the website and tutorials helpful, please consider donating to keep the lights on.
Here is what the final chart should look like:
Below are step by steps for each of the 3 methods and video is linked at the end of the post. One above Tuesday and one above Thursday. So he sent me a sample chart (see the Excel Line chart pictured below) and he wanted to add 2 vertical lines. Recently, Don sent me an email and asked if I could help him add a vertical line to a chart in Excel. Don also likes to use Excel to track everything about the Doctor Who series. Don is a retiree living in the Mid-west of the USA and he likes to track things using Excel and then he likes to see his data visually. So I have a good friend that was here at the start of my Excel Dashboard Template blog and his name is Don. I am off to Darwin and Singapore next so hopefully I can get more posts completed on the flights. We had a successful launch in Melbourne and Perth.
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish.
0 kommentar(er)
