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

Answer: Connect bars in a column chart
 

Yes, it is possible to connect the tops of columns in a multi-column chart with a line to show a trendline for the series. Here are the steps to follow:

1. Select the chart you want to modify.
2. Click on the "Design" tab in the ribbon.
3. Click on the "Select Data" button in the "Data" group.
4. In the "Select Data Source" dialog box, click on the "Edit" button under [b]"Legend Entries (Series)."
5. In the "Edit Series" dialog box, select the series you want to modify and click on the "Edit" button under "Series Values."
6. In the "Edit Series" dialog box, select the range of cells that contain the data for the series.
7. Click on the "OK" button to close the "Edit Series" dialog box.
8. Click on the "OK" button to close the "Select Data Source" dialog box.
9. Right-click on one of the columns in the series you just modified and select "Format Data Series" from the context menu.
10. In the "Format Data Series" pane, select the "Fill & Line" tab.
11. Under "Line," select the "Solid line" option.
12. Under "Dash Type," select the type of line you want to use to connect the tops of the columns.
13. Under "Cap Type," select the "Flat" option.
14. Adjust the "Width" and "Color" options as desired.
15. Click on the "Close" button to close the "Format Data Series" pane.

The line should now connect the tops of the columns in the series you modified. You can repeat these steps for any other series in the chart that you want to modify.

Connect bars in a column chart
 

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

Connect bars in a column chart
 

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

.

Connect bars in a column chart
 

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

.

Connect bars in a column chart
 

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