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 quot;stackquot; and series lines
between column elements. Any help adding Lines for three data series to and
existing stacked column chart will be most appreciated.
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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______
quot;ancillariesquot; gt; wrote in message
...
gt; My application requires a stacked colunm chart with series lines combined
gt; with a minimum of three (3) data series represented as lines. Using the
gt; combined column-line chart I loose both the column quot;stackquot; and series
gt; lines
gt; between column elements. Any help adding Lines for three data series to
gt; and
gt; existing stacked column chart will be most appreciated.
- Mar 13 Thu 2008 20:43
Combine stacked column and line chart w/series lines
close
全站熱搜
留言列表
發表留言