Lines and columns in charts

[Luke]

I am trying to create a 'Line - Column on 2 axes' chart with the market share of 5 companies on one Y axis and the total market volume on the other (X axis is months). I want the market shares to be lines, and the market volume to be columns. I can set which axis each series relates to, but I can't change those series to lines if they are columns, and vice versa.

Any ideas?

 

[Debra Dalgleish]

You can select a series, then select a chart type from the Chart Type
dropdown on the Chart toolbar.

Or, create your own combination chart -- Jon Peltier has instructions on
his web site:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html