Conditional Formatting On Data Table In A Chart

[Samnuni]

Hi all,

I am currently using Excel 2007.

I have created a stacking bar chart based on sales information for the past 5 years by month. Currently, I have the chart and the data table displayed on the graph (chart layout) with the averages displayed as a second axis and I am wondering if it's possible for it to hightlight the highest sold months in the data table?

Thanks,

-- Sam

 

[Samnuni]

Guess I can't edit this thread.

What I meant to ask was how can I condition format the legend when it's showing all the data.

Thanks,

-- Sam