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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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 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" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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

Thanks again Andy!! It worked perfectly!


"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SLKoelker" wrote in message
...
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