Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2005
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional chart formatting (2000/2002/2003)

    Does Excel have the ability to apply conditional formatting to bar graphs, i.e. have a column change color automically if the value exceeds some predefined value. Is it possible to do this with VBA?

    Thanks!

    Larry

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional chart formatting (2000/2002/2003)

    Hi Larry

    Jon Peltier has some great examples on how to provide conditional formatting to graphs.

    Conditional charts-example 1

    Conditional charts-example 2

    I hope these help
    Jerry

  3. #3
    Lounger
    Join Date
    Dec 2005
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional chart formatting (2000/2002/2003)

    Jerry - this is perfect - thanks for the assistance! Larry

Posting Permissions

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