Connect bars in a column chart

  • Thread starter Thread starter I Teach
  • Start date Start date
I

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.
 
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
 
Thank you, Bernard. I cannot seem to get this to work the way I want. Please
send me an example.

Thank you.
 
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
 
Back
Top