Conditional formatting of charts
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional formatting of charts

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'd like to be able to conditionally format the data series of a chart depending on the results - is this possible? If so, how?

    I'm heavily involved in service level agreements and would like the colour of the data series to show either Red, Orange or Green depending on whether or not we meet our targets.

    Any ideas?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What Chart Type are you using? Can you provide some sample data along with a detailed explanation?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I'm just using a straightforward bar chart.
    The type of conditions I'm using are as follows:

    Percentage of Calls not Completed (for example)
    >=15% then bar would be Red
    Between 10-15% then bar would be Orange and
    <=10% then bar would be Green

    Hope this helps.

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