Results 1 to 10 of 10
  1. #1
    JimDandy
    Guest

    Bar Chart (2003)

    I made a barchart (couldn't attach -file too big) and I was wondering, how can I flag the highest 3 numbers so they stand out a little more from the rest of the bars. I was thinking of making the bars different colors, but I can't figure out how to do it.

  2. #2
    New Lounger
    Join Date
    Jun 2006
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart (2003)

    can zip the workbook and attach?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bar Chart (2003)

    Does this technique work for you?

    Steve

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Bar Chart (2003)

    If you don't mind doing it manually, you can select the individual chart series points and format them separately. First click on any point or column to select the entire series, pause a moment, then select the individual point or column that you want to format differently. Ctrl-1 is a quick keyboard shortcut to format whatever is selected.

    Aloha!

  5. #5
    JimDandy
    Guest

    Re: Bar Chart (2003)

    Thanks everyone, I tried the CTRL 1 manua format l technique, but all the bars changed color. How do I select the particular bar that I want to change?

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bar Chart (2003)

    I do it by first selecting the series
    Then while that is selected
    Dbl-click the bar to manually change

    Steve

  7. #7
    JimDandy
    Guest

    Re: Bar Chart (2003)

    I like this, I don't know what determines the color though?, I did look at the formulas and see how it finds the largest value. thanks

  8. #8
    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: Bar Chart (2003)

    Jim

    It took me a little while to work out what Steve had done in the example. He has created two series, the green one and the cream one. Hence by do this you can colour the individual series. A nice simple method to try.

    I have been playing with an alternative method using the REP function which allows you to repeat a specific value a certain number of times e.g. =rept("|",20) repeats the | character 20 times. By doing this you can create an "on sheet" graph. Using a simple if statement, text alignment and colouring you can create a very effective horizontal bar chart with colouring. I have attached an example. Sorry if this has gone off topic but it is quite a useful tool.
    Jerry

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bar Chart (2003)

    To expand on what Jerry wrote:
    It is a stacked column chart with 2 series

    I calculate whether an item is in one series or the other based on the size compared to the 3 largest value (LARGE function with 3 as 2nd parameter)

    You can change the color by dbl-clicking the range. as teh numbers change the chart will automatically be updated. Depending on values you will get 3 (and more depending on the ties) of a different color

    Steve

  10. #10
    JimDandy
    Guest

    Re: Bar Chart (2003)

    Thanks again, this is the fix I needed.

Posting Permissions

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