OKay I found this tutorial on Conditional Formatting in a chart using numerical values Conditional Formatting of Excel Charts | Peltier Tech Blog | Excel Charts However I have a series of ticket types and I want to put a trend chart together that has the various ticket types in diffrent colors based on the ticket value.
My Data values are as such
My Data values are as such
Code:
Active Ticket #
Ticket Type Open, Closed, In Process, Etc...
a hidden band
Limit Band 5 points