View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Layering Chart Types

Create a stacked column chart with all 4 series in it. Then, select the
series you want to become a line. Go to Chart, Chart type, and pick a line
series. Then, again selecting the same series, right-click, format, axis,
move to secondary axis
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeff" wrote:

I would like to layer a line graph on a second y axis on top of a "stacked
column" graph with 3 data series in it. Anyone know how to do this?