Using Conditional Formatting with a Chart

[RobWulf]

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

Active Ticket #
Ticket Type   Open, Closed, In Process, Etc...

a hidden band 

Limit Band 5 points

 

[Jon Peltier]

There isn't enough information about what you want to plot.

 

[RobWulf]

There isn't enough information about what you want to plot.

I am trying to change the various points on the chart based on their type right below the ticket number

[TABLE="width: 1193"]
<TBODY>[TR]
[TD]Active Tickets</SPAN>[/TD]
[TD="align: right"]71598</SPAN>[/TD]
[TD="align: right"]68204</SPAN>[/TD]
[TD="align: right"]67927</SPAN>[/TD]
[TD="align: right"]68749</SPAN>[/TD]
[TD="align: right"]72019</SPAN>[/TD]
[TD="align: right"]72283</SPAN>[/TD]
[TD="align: right"]74354</SPAN>[/TD]
[TD="align: right"]71706</SPAN>[/TD]
[TD="align: right"]53376</SPAN>[/TD]
[TD="align: right"]70029</SPAN>[/TD]
[TD="align: right"]62079</SPAN>[/TD]
[TD="align: right"]67920</SPAN>[/TD]
[TD="align: right"]70027</SPAN>[/TD]
[TD="align: right"]66461</SPAN>[/TD]
[TD="align: right"]65231</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Open[/TD]
[TD]Open[/TD]
[TD]Closed</SPAN>[/TD]
[TD]Closed</SPAN>[/TD]
[TD]In Process</SPAN>[/TD]
[TD]In Process</SPAN>[/TD]
[TD]Open[/TD]
[TD]Closed</SPAN>[/TD]
[TD]Closed</SPAN>[/TD]
[TD]Open[/TD]
[TD]Hold</SPAN>[/TD]
[TD]Open[/TD]
[TD]Open[/TD]
[TD]In Process</SPAN>[/TD]
[TD]Hold</SPAN>[/TD]
[/TR]
[TR]
[TD]days at state[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]89</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[TD="align: right"]13</SPAN>[/TD]
[TD="align: right"]195</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]9</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[/TR]
[TR]
[TD]30 Day Limit</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=4><COL span=11></COLGROUP>[/TABLE]

 

[Jon Peltier]

So that's the data, what about the chart? What's the chart type, what are the X and Y values, and shall we presume that those values are ticket identifiers and not counts of tickets?

 

[RobWulf]

So that's the data, what about the chart? What's the chart type, what are the X and Y values, and shall we presume that those values are ticket identifiers and not counts of tickets?

Jon I am using a banded chart like the one here: How-to create a horizontal banding in an Excel Line Chart | Excel Dashboard Templates

Horiziontal value is a count from 0 - 1000 based on the days at state.

30 is our threshold limit and the 1 is the band size.