I believe I have seen before where you can set your X Axis labels to be formatted in different colors. For example, I have a listing of inventory by block, B1 - B10, and if the block has more than 500 in inventory I want the axis label to be red, otherwise I want the axis label to be black.
So for the following data I would like B7 and B9 to be red and the others to be black.
B1 200
B2 400
B3 300
B4 450
B5 350
B6 150
B7 600
B8 400
B9 550
B10 100
Any thoughts?
PS I am using Excel 2003.
So for the following data I would like B7 and B9 to be red and the others to be black.
B1 200
B2 400
B3 300
B4 450
B5 350
B6 150
B7 600
B8 400
B9 550
B10 100
Any thoughts?
PS I am using Excel 2003.