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. |
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 |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com