Re: multiple colors on area chart

Hey John, thanks for your help!

The recession data is on the secondary axis with a chart type "columns." It
is the only data on the secondary axis and I would prefer to keep it
there.... I've changed the chart type of the recession data to column
stacked, but to no avail. How do I plot the recession area series as stacked
on the other data? and would that allow me to "hide" the recession bars
behind the colored "area" of the primary axis data? (the primary axis data is
charted as an "area" chart.

Thanks again!

"Jon Peltier" wrote:

Are the recession bars also an area chart? If so, put them on the primary
axis and the other data on the secondary. Or plot the recession area series
as stacked on the other data, such that it brings the total to whatever Ymax
you need.

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


"Roger" <Roger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2304FE92-B5F3-4DE6-A4FB-23119BEC3CCA@xxxxxxxxxxxxxxxx
Jon,
Thanks for the info!

The only problem I'm having now is making the recession bars (vertical)
appear "behind" the area chart. My recession bar cover the color in the
area.

Any ideas?
Thanks again!
Roger

"Jon Peltier" wrote:

Plot two series in a stacked area chart, one that has the value when the
chart shows red (and zero otherwise) and the other that has the value
when
the chart shows green (and zero otherwise). If the data points are close
enough, you will not notice that the division between colored sections is
not quite vertical.

If you need to tweak the chart to make the transitions exactly vertical,
you
can accomplish this with an inserted data point at each transition.

Here is the data before inserting the point:

Date All Red Green
1/30/07 125.86 125.86 0
1/31/07 125.30 125.30 0
2/1/07 126.85 0 126.85
2/2/07 129.17 0 129.17

The Red area slopes down from 125.30 on 1/31 to zero on 2/1. If I'm
plotting
only a two month set of data, this slope will be noticeable.

Insert a point that duplicates one of the dates. In a line or area chart
with a time scale axis, two values for the same date are plotted
vertically
aligned.

Date All Red Green
1/30/07 125.86 125.86 0
1/31/07 125.30 125.30 0
2/1/07 126.85 126.85 0
2/1/07 126.85 0 126.85
2/2/07 129.17 0 129.17

The Red area now drops from 126.85 to zero on 2/1. You can change the
date
of the transition to 1/31 if desired, if it seems to represent the timing
of
the drop more accurately, but you do have to pick an integral date, not
the
half date in between 1/31 and 2/1, because the time axis only recognizes
the
whole number days, not the hours (fractional days).

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


"Roger" <Roger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6AA07397-D4CA-46B6-9103-62B27E573C1C@xxxxxxxxxxxxxxxx
I've designed a chart with dates (months) on the X axis and numbers
(percent)
on the Y axis. Currently, I am using the "Area" chart type which
colors
the
entire area below the graph line as one solid color.

I wish to have the color change from one color to another at certain
points
on the X axis. An example of something similar is found at the bottom
of
the
linked page:

http://gueriteadvisors.com/Strategy/indicators.cfm

any help would be greatly appreciated!!








.

Relevant Pages

  • Re: multiple colors on area chart
    ... If your recession data is plotted on the primary axis as another area series ... Jon Peltier, Microsoft Excel MVP ... The recession data is on the secondary axis with a chart type "columns." ...
    (microsoft.public.excel.charting)
  • Re: P & V chart: Secondary X axis gradient (again)
    ... >price as XY. ... Line chart. ... Right click on the Volume series, select Chart Type ... Double click on the X axis, ...
    (microsoft.public.excel.charting)
  • RE: mix chart types
    ... A combination chart uses two or more chart types to emphasize that the chart ... change the chart type for one or more of the data series in the chart. ... Secondary axis... ...
    (microsoft.public.powerpoint)
  • Re: category Axis
    ... Use the SeriesCollection.NewSeries method to add a series to the chart: ... Assign the data, series type, and axis group: ... each series has distinct X and Y values in this chart type. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: charts plotted with data on two axes
    ... Use the x-y chart type. ... Both axes are value axes, ... x axis being a category axis. ...
    (microsoft.public.excel.misc)