Using Conditional Formatting with a Chart

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Using Conditional Formatting with a Chart

  1. #1
    Board Regular
    Join Date
    Apr 2013
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,400
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Conditional Formatting with a Chart

    There isn't enough information about what you want to plot.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  3. #3
    Board Regular
    Join Date
    Apr 2013
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Conditional Formatting with a Chart

    Quote Originally Posted by Jon Peltier View Post
    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. #4
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,400
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default 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?
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  5. #5
    Board Regular
    Join Date
    Apr 2013
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using Conditional Formatting with a Chart

      
    Quote Originally Posted by Jon Peltier View Post
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com