close

I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help!

Hi,

Create the chart using all the data as a stacked column chart.
Double click the series that you want as a line on the secondary axis.
On the Axes tab select Secondary axis. The right click the series and
pick Chart type to change it the required line chart type.

Cheers
Andy

rwtuning wrote:
gt; I want to have a combination chart on 2 axis. I want the columns to be
gt; stacked. I want the line to be on a second Y axis....please help!

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()