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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
There isn't enough information about what you want to plot.
 

RobWulf

Board Regular
Joined
Apr 19, 2013
Messages
76
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]
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
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

Board Regular
Joined
Apr 19, 2013
Messages
76

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,576
Members
405,410
Latest member
NAnsari

This Week's Hot Topics

Top