Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column & Line Charts
How do I change a chart data line into a column? When I select the Column &
Line Chart option I get half Columns and the other half Lines. I want to control which data series is shown as a column and which data series is shown as a line. |
#2
|
|||
|
|||
Instead of using the built-in combination charts, you can create your
own. Jon Peltier has instructions on his web site: http://www.peltiertech.com/Excel/Cha...mboChart1.html To change your chart: Select the chart From the Chart menu, choose Chart Type Select the Column chart type Click OK In the chart, select the series that you want as a line From the Chart menu, choose Chart Type Select the Line chart type Select one of the Line chart subtype Click OK CapitalRob wrote: How do I change a chart data line into a column? When I select the Column & Line Chart option I get half Columns and the other half Lines. I want to control which data series is shown as a column and which data series is shown as a line. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppress zero values in line charts? | Charts and Charting in Excel | |||
Can I post dynamic line charts by swapping out .cvs files??? | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Column Chart to Line Chart | New Users to Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel |