David wrote:
I have a stacked bar chart with multiple bars, each with
multiple data points. I would like to loop thru each data
point and change the chart color for each point based on
the original cell value.


I think you are out of luck.
Colours are set at the series level, not the point level.
The only variation you can get is InvertIfNegative (which is unlikely
to be useful in a stacked bar chart).

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup