Line Graph in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

You need to do the addition in a separate column using formula. The chart
just plots information it does not perform calculations prior to plotting.

Cheers
Andy
 
Hi again,

Can you tell me a little more information, what formula? Maybe an Example of
what the input data will look like?

Thanks,
Stephanie
 
Andy Pope said:
Hi,

You need to do the addition in a separate column using formula. The chart
just plots information it does not perform calculations prior to plotting.

Cheers
Andy
Click to expand...
 
Assuming your test data is in the range A1:D5

E2: =A2
F2: =B2+D2
G2: =C2

Copy the formula down to row 5.
Add labels in F1 and G1 for series.
Create chart based on range E1:G5

Cheers
Andy
 
Back
Top