1. 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. Re: Bar Chart (2003)

can zip the workbook and attach?

3. Re: Bar Chart (2003)

Does this technique work for you?

Steve

4. 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. 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. 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. 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. 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.

9. 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. 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
•