Combining Chart Styles
 

How chan I display a data series as a line in an Area Chart in Excel?

Combining Chart Styles
 

On Tue, 22 May 2007, in microsoft.public.excel.charting,
BTomS said:

How can I display a data series as a line in an Area Chart in Excel?

Bring the data series in as an area chart series, right click on the
area series, select "Chart Type" and change the type of the series from
Area to Line (or Scatter).

The secret is that Chart Type is a separate property of each series, not
a fixed property of whole charts. So you can mix and match series almost
any way you like, with a few exceptions.

The Combination Chart type is a bit pointless once you learn how to do
combinations yourself, and I never use it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Combining Chart Styles
 

Del,
Thanks. For some reason I can't go straight to line. I traied that all day
to day. But based on your reply, I tried changin it to scatter and then
changing that to line and it worked. Appreciate your help.

"Del Cotter" wrote:

On Tue, 22 May 2007, in microsoft.public.excel.charting,
BTomS said:

How can I display a data series as a line in an Area Chart in Excel?

Bring the data series in as an area chart series, right click on the
area series, select "Chart Type" and change the type of the series from
Area to Line (or Scatter).

The secret is that Chart Type is a separate property of each series, not
a fixed property of whole charts. So you can mix and match series almost
any way you like, with a few exceptions.

The Combination Chart type is a bit pointless once you learn how to do
combinations yourself, and I never use it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.