View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do i create a user defined chart in Powerpoint or excel?

Hi,

It is simpler to create a stacked column chart using all the data and
then select and change the appropriate data series to be a line chart.
The you can then format the line series to use the secondary axis.

Cheers
Andy

Magnus wrote:
I'm looking to create a graph chart with 3 series as bar charts,
accumulated/stacked on the first Y axis, and teh fourth series as a line on
the secondary y axis. i have tried to use the custom chart with lines7
colummn on two axes, but thuis does not allow to show bars as accumulated
/stacked.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info