Using Conditional Formatting with a Chart

RobWulf

Board Regular
Joined
Apr 19, 2013
Messages
76
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
Code:
Active Ticket #
Ticket Type   Open, Closed, In Process, Etc...

a hidden band 

Limit Band 5 points
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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


Code:
[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]
 
Upvote 0
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?
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top