I have created a line graph in Excel (with my input data on a separate
worksheet). I have 3 columns: Planned, Actual, and New. I am tracking
'requirements' and I only want 2 lines on the graph. I have plotted the
Planned and Actual, however I want the 'New' to be added to the 'Planned' in
the graph. Maybe my example below will help?

      Planned            Actual          New
A       10                   8                 0
B       15                   12               2
C       20                   17               0
D       25                   23               2

The above is how my input data looks. What I want the graph to show is for
'B' the planned point should be at 17 (not a separate line for New) or for
'D' the Planned point should be at 27.

Is there a way to do this?

Thanks in advance,
Stephanie