+ Reply to Thread
Results 1 to 2 of 2

Different chart color for certain dates

  1. #1
    Registered User
    Join Date
    10-25-2006
    Posts
    48

    Different chart color for certain dates

    Hello, I produce a simple pivot bar chart with date on X and the count of apples sold on Y, based on the data of 2 years.

    These are the columns :
    YEAR, Month, Day, WeekDay, Apples_Count

    My question is, on the chart, how can I automatically highlight (paint in red for example), all bars that show values from fridays ?

    Thanks !

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Different chart color for certain dates

    Please attach a sample workbook so we can help you better.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Color the column bars of a chart the same color as the text in the underlying data
    By ajm1991 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2016, 04:55 PM
  2. Apply Color to chart based on Data source text color
    By ajm1991 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2016, 08:41 PM
  3. make chart label color same color as data point
    By desertsp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2013, 05:02 PM
  4. [SOLVED] Color Chart Data Points By Cell Color
    By smile0 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 06-10-2012, 04:42 PM
  5. Still need help with Color start and end dates on Gnatt chart"
    By Kristina1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2010, 12:39 PM
  6. How do I connect cell color to bar chart color?
    By Bob Freerks in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2005, 07:06 PM

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