View Single Post
  #3   Report Post  
BorisS
 
Posts: n/a
Default

very nice. So I take it that this it the way to do all combinations? Get
the base (majority) done first, then just take any one series and convert it
to a different type? Can you do more than two types on a chart? If so, is
there a limit?

This is great. Opens up quite a set of possibilities for getting creative.
Does second axis pose a problem in these cases, if converting to that? Any
sorts of tips to avoid?

Thx so much.
--
Boris


"Jon Peltier" wrote:

Plot all series together in a stacked area chart. Select the series you
want converted to a line, go to Chart Type on the Chart menu, and select
the chart type you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


BorisS wrote:

I am using '03, and need a chart that has a few series in area buildup view
(filled sections which build on top of themselves), with one other series
that appears over that area as a line. Any help? Thx.