Hey everyone. My company has recently asked me to make a chart based on some data on various expenses on a given week for a given area. I have the data table formatted so the highest number value's text is turned to red. I am wondering if there is any way to get the chart to automatically change the color the same way like i have already below with out having to put in any input other than the numbers. There are going to be many weeks involved for each area so it would make life a lot easier.
[/IMG]