Connect bars in a column chart

[I Teach]

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.

 

[Bernard Liengme]

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

 

[I Teach]

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

Thank you.

 

[Bernard Liengme]

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

 

[Herbert Seidenberg]

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