Column & Line Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/Charts/ComboChart1.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
 
Back
Top