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!!

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" wrote in message
...
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!!

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" wrote in message
...
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!!

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" wrote in message
...
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" wrote in message
...
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!!

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" wrote in message
...
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" wrote in message
...
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!!

Hi Roger,

I have examples showing how to do this with an Area/Stacked Column or with
just Stacked Columns.

I'll send you the file if you want and you can tell me which one works for
you and I'll give you all the steps if it's not obvious. Let me know.


--
Cheers,
Shane Devenshire


"Roger" wrote:

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!!

If your recession data is plotted on the primary axis as another area series
stacked on the others, with a value of {Ymax - other value}, and using the
duplicate points to get a vertical transition, it will work. I was actually
doing this in a dummy file as I wrote the earlier response.

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


"Roger" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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!!

Shane, I would greatly appreciate your example. If you would, please send to
(a temporary email account).

Thanks for your help!
Roger

"ShaneDevenshire" wrote:

Hi Roger,

I have examples showing how to do this with an Area/Stacked Column or with
just Stacked Columns.

I'll send you the file if you want and you can tell me which one works for
you and I'll give you all the steps if it's not obvious. Let me know.


--
Cheers,
Shane Devenshire


"Roger" wrote:

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!!