PC Review


Reply
Thread Tools Rate Thread

Combine stacked column and line chart w/series lines

 
 
=?Utf-8?B?YW5jaWxsYXJpZXM=?=
Guest
Posts: n/a
 
      7th Apr 2006
My application requires a stacked colunm chart with series lines combined
with a minimum of three (3) data series represented as lines. Using the
combined column-line chart I loose both the column "stack" and series lines
between column elements. Any help adding Lines for three data series to and
existing stacked column chart will be most appreciated.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      7th Apr 2006
The built-in custom types have limited usefulness. Here's how to make your
own combination charts.

Plot all data as stacked columns. Double click a column and on the Options
tab, select Series Lines. Select a series you want changed to a line, choose
Chart Type from the Chart menu, and choose the line style you want. Repeat
for another series, or press the F4 key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"ancillaries" <(E-Mail Removed)> wrote in message
news:7F81074F-9F46-488A-A4F8-(E-Mail Removed)...
> My application requires a stacked colunm chart with series lines combined
> with a minimum of three (3) data series represented as lines. Using the
> combined column-line chart I loose both the column "stack" and series
> lines
> between column elements. Any help adding Lines for three data series to
> and
> existing stacked column chart will be most appreciated.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I combine a stacked column chart and line chart? Huib Microsoft Excel Charting 1 22nd Oct 2009 10:41 AM
how do I add series lines to a an excel stacked chart =?Utf-8?B?a2FsYW4=?= Microsoft Excel Charting 2 5th Sep 2006 09:58 AM
How do I combine a line and a percentage stacked column chart? =?Utf-8?B?TGl6YQ==?= Microsoft Excel Charting 1 3rd Feb 2005 01:40 PM
Multiple Series of Series in Stacked Column chart? nlee144(NoSpamTakeSquareRootOfNumber) Microsoft Excel Charting 2 5th Jun 2004 03:31 AM
Re: Combined columnar chart(3 - 5 columns) and stacked column (1 column, 2 series) as one chart Nicky Microsoft Excel Charting 1 8th Apr 2004 07:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:30 PM.