Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combining Chart Styles
How chan I display a data series as a line in an Area Chart in Excel?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Chart types | Charts and Charting in Excel | |||
Combine two different chart styles on one chart | Charts and Charting in Excel | |||
Chart line styles | Charts and Charting in Excel | |||
Creating custom chart legen pallettes/styles symbols | Charts and Charting in Excel | |||
Combining Information in a Bar Chart | Charts and Charting in Excel |