Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
|
|||
|
|||
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:
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart narrow bars wanted | Charts and Charting in Excel | |||
different colors for bars in a column chart | New Users to Excel | |||
2d-Column (Clustered Column) chart with Standard Deviation Bars | Charts and Charting in Excel | |||
Column Chart Thickness of Bars | Charts and Charting in Excel | |||
Excel column chart with a 2ndary y axis w/o bars overplotting? | Charts and Charting in Excel |