Thanks:  0
Likes:  0

# Thread: Using Conditional Formatting with a Chart

1. ## Using Conditional Formatting with a Chart

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```

2. ## Re: Using Conditional Formatting with a Chart

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

3. ## Re: Using Conditional Formatting with a Chart

Originally Posted by Jon Peltier
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:
```Active Tickets
71598
68204
67927
68749
72019
72283
74354
71706
53376
70029
62079
67920
70027
66461
65231

Open
Open
Closed
Closed
In Process
In Process
Open
Closed
Closed
Open
Hold
Open
Open
In Process
Hold

days at state
11
89
11
11
11
11
11
11
11
13
195
1
1
6
9

30
30
30
30
30
30
30
30
30
30
30
30
30
30
30

30 Day Limit
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

```

4. ## Re: Using Conditional Formatting with a Chart

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?

5. ## Re: Using Conditional Formatting with a Chart

Originally Posted by 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?

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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•