close

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.

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

    software

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