+ Reply to Thread
Results 1 to 5 of 5

chart colors to match colors in chart

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,892

    Re: chart colors to match colors in chart

    You have three colors, but only one data series. Columns in a single data series must all be the same color. You would have to create three series. See attached for revised chart plus code to format.

    This assumes that each data series has a single data point.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change bar chart colors to be consistent with another chart
    By Larry.LeBlanc@O in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-17-2014, 08:26 PM
  2. Bar of Pie Chart - Colors
    By Hanaymous in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2014, 04:01 AM
  3. Change bar chart fill colors to match the color of a random cell
    By gwbe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2014, 08:12 PM
  4. Can I change the color of labels in a 3D pie chart to match cell colors?
    By Macphersonian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 12:07 PM
  5. Replies: 0
    Last Post: 08-07-2012, 03:54 PM
  6. Chart Colors
    By Coors in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-14-2008, 04:23 AM
  7. [SOLVED] static colors in chart chart
    By Johan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-22-2005, 09:05 AM

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