stacked column chart with 3 fixed amount ranges
 

Hi!

I would like to create a stacked column chart based on 3 fixed amount ranges.

For example, within a bar, the section with the amount less than $4 will be
yellow. The section from $4 to $6 will be green. The section with amount
more than $6 will be blue.

Thank you very much!

Ken

stacked column chart with 3 fixed amount ranges
 

Something like this?

http://peltiertech.com/Excel/Charts/...nalChart1.html
http://peltiertech.com/Excel/Charts/...nalChart2.html

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


"Ken" wrote in message
...
Hi!

I would like to create a stacked column chart based on 3 fixed amount
ranges.

For example, within a bar, the section with the amount less than $4 will
be
yellow. The section from $4 to $6 will be green. The section with amount
more than $6 will be blue.

Thank you very much!

Ken

stacked column chart with 3 fixed amount ranges
 

Jon,

The link is very helpful. Thank you very much!

Ken