Target and Line Chart

Use a Line Chart to Display Data Over Time

Line Chart

Line Charts are one of the most popular charts used. A line chart has an X axis (horizontal axis on the bottom) and a Y axis (vertical axis to the left). The X axis almost always represents time (hours, days, months, etc.) Therefore, in some industries, a line chart is referred to as a Time Series Chart.

Target Line

A Target Line is used to compare the actual value of your data set to that of your projection or goal.


To open the template, click on the QI Macros menu and select, Chart Templates, Target and Line Chart:

chart templates menu


To complete the Target and Line Chart template:

  1. Input your Baseline in cell E1 and the first date that the baseline applies in F1.
  2. Next, input your Target in H1 and date due in I1.
  3. Then, set your Revision Date in K1.
  4. Lastly, input your dates and data in cells A2 through B52:

Target and Line Chart Template in Excel

To create a Target And Line Chart using QI Macros...
Try It Now!