Connect bars in a column chart

I would like to connect the tops of columns with a line in a multi-column
chart so that the line shows something like a trendline for the series.
Trendlines don't seem to show me what I would like to see.

I am using Excel 2007. Please let me know if this is possible.
--
I Teach

You will need to have each data series entered twice and convert one 'twin'
to a Line chart.
1) Select the range of cells for the first data series (just the y-values)
and Copy
2) Click the chart to 'activate' it
3) On the Home tab, launch the paste icon and select Paste Special; specify
New Series
4) On the chart, right click the newly added column; select Change Series
Chart Type; select Line
5) Format the new line to show line with no markers
Repeat all steps for every data series
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"I Teach" wrote in message
...
I would like to connect the tops of columns with a line in a multi-column
chart so that the line shows something like a trendline for the series.
Trendlines don't seem to show me what I would like to see.

I am using Excel 2007. Please let me know if this is possible.
--
I Teach

Thank you, Bernard. I cannot seem to get this to work the way I want. Please
send me an example.

Thank you.
--
I Teach


"Bernard Liengme" wrote:

You will need to have each data series entered twice and convert one 'twin'
to a Line chart.
1) Select the range of cells for the first data series (just the y-values)
and Copy
2) Click the chart to 'activate' it
3) On the Home tab, launch the paste icon and select Paste Special; specify
New Series
4) On the chart, right click the newly added column; select Change Series
Chart Type; select Line
5) Format the new line to show line with no markers
Repeat all steps for every data series
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"I Teach" wrote in message
...
I would like to connect the tops of columns with a line in a multi-column
chart so that the line shows something like a trendline for the series.
Trendlines don't seem to show me what I would like to see.

I am using Excel 2007. Please let me know if this is possible.
--
I Teach

.

I cannot send a file to the newsgroup.
Please email me directly - get my email addy from my website
(it you see my email addy in this message just remove TRUENORTH. )
Then I can send a file directly to you
I will include a short movie made as I do it.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"I Teach" wrote in message
...
Thank you, Bernard. I cannot seem to get this to work the way I want.
Please
send me an example.

Thank you.
--
I Teach


"Bernard Liengme" wrote:

You will need to have each data series entered twice and convert one
'twin'
to a Line chart.
1) Select the range of cells for the first data series (just the
y-values)
and Copy
2) Click the chart to 'activate' it
3) On the Home tab, launch the paste icon and select Paste Special;
specify
New Series
4) On the chart, right click the newly added column; select Change Series
Chart Type; select Line
5) Format the new line to show line with no markers
Repeat all steps for every data series
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"I Teach" wrote in message
...
I would like to connect the tops of columns with a line in a
multi-column
chart so that the line shows something like a trendline for the series.
Trendlines don't seem to show me what I would like to see.

I am using Excel 2007. Please let me know if this is possible.
--
I Teach

.

Excel 2007 PivotChart
Connect column tops with line.
An example file for the whole newsgroup.
http://www.mediafire.com/file/1jynyzt2w2y/01_24_10.xlsx