Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    coloured bars (Excel 97 SR2)

    Is there a way to automatically colour certain bars in a chart depending on the value of the bar?

    I know I can go through and manually alter each bar but it would be neat if, say, A6:A10 held the series for the bar chart and the value in A3 was odd in someway and the bar for A3 was automatically coloured red while the rest remain black.

    If you offer a VBA solution, be gentle please.

    stuck

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: coloured bars (Excel 97 SR2)

    Have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=62019&page=&view= &sb=&o=&vc=1>this thread</A> for something similar.

Posting Permissions

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