If you want to follow the example in this tutorial, you can download the Excel spreadsheet * HERE*. Using the Chart Wizard, create an XY (Scatter) chart with time on the x-axis and your numeric data on the y-axis. Step 1: Create an XY (Scatter) chart…įor this example, feed subscribers for the month of May is being used. Thankfully, there’s a “hack” that can eliminate the hassle of drawing vertical lines while allowing you to instantly change their position with a few mouse clicks. The issue is that these lines aren’t bound to the x-axis, so any change to the chart is usually accompanied by manual line repositioning. Normally, one turns to the line tool in Excel to manually draw vertical lines on a chart.
