+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 - Cannot add colors to a charts data table

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, Tennessee
    MS-Off Ver
    Excel 2010
    Posts
    4

    Excel 2010 - Cannot add colors to a charts data table

    Is there a way to fill in a data table w/ colors? It appears to be pretty static and not flexible. I would like to be able to add backgound colors to the cells so that ones eyes can gravitate to the data. Please review the attachment for clarity.

    Thanks

    VJ
    Attached Images Attached Images
    Last edited by venetian_jigsaw; 07-08-2011 at 05:15 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,078

    Re: Excel 2010 - Cannot add colors to a charts data table

    As you have discovered the formatting is very limited.

    Better to use cells to build your own table.
    http://tushar-mehta.com/excel/newsgr...able/index.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-08-2011
    Location
    Memphis, Tennessee
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel 2010 - Cannot add colors to a charts data table

    Andy, thanks for the response. This is what I was afraid of, but thought I would give a shot to see if there is a work around. Since my group at work is involved in the Microsoft Technology Adoption Program (TAP), we might suggest.

    VJ

+ 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