+ Reply to Thread
Results 1 to 3 of 3

block chart has same colour for block, how to auto random the colours?

  1. #1
    Registered User
    Join Date
    05-07-2007
    Location
    England
    MS-Off Ver
    2010
    Posts
    47

    block chart has same colour for block, how to auto random the colours?

    Wanting to have a block chart but all the blocks are the same colour, how can i get it to show different colours automatically without having to alter each and everyone of them manually?

    I was able to do this with a piechart but the pie chart is not needed as it is not easy to read with my figures so wanting to use a block chart instead.

    i am using Excel 2002
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: block chart has same colour for block, how to auto random the colours?

    Hi,

    Click the data series you want to change the colours for.

    On the Format menu, click Selected Data Series .Click the Options tab.

    Select "vary colours by point" check box.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: block chart has same colour for block, how to auto random the colours?

    Alternatively, select the chart, click Chart - Source data - tick "Series in - Rows"

    This will make each row of data an individual chart series that you can format any way you want.

    cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1