View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Creating custom charts

Forget the built-in options. It is easy to make your own combination charts
which can be so much more flexible.

Start by making the chart using the predominant series type, in your case,
stacked column. Select a series which you want to change to a line type, go
to Chart menu, Chart Type, and select the line type you want. Repeat as
necessary. To put any series onto a secondary axis, double click on it, and
go to the Axis tab.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Taebaek" wrote in message
...
Does anyone know a way to create a chart that combines the stacked column
chart with a line or scatter chart. I know there is a combo chart but
that
will not let me use a stacked column