+ Reply to Thread
Results 1 to 4 of 4

Dynamically changing color of the last bar in a bar chart

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Dynamically changing color of the last bar in a bar chart

    Hi,

    Somebody has asked me to prepare a bar chart showing weekly progress of some KPI. The chart covers an entire year and when a new week starts there would be a new bar. They wanted that bar to be of a different color than the rest. Once that week ends, that bar would become colored the same way as the rest and the new week would have a new bar colored differently.

    I don't really know of any excel standard features allowing this, but I'm not very good with charts. Is VBA my only option?

    Thanks for your help.

    V.G.
    Attached Files Attached Files
    Last edited by ValGlad; 05-20-2015 at 04:07 PM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Dynamically changing color of the last bar in a bar chart

    You just need to split your data into two - one set for all the weeks except the newest, and one for just the newest - using formulas. See the attached file.

    Book1.xlsx
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    03-02-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Dynamically changing color of the last bar in a bar chart

    Wow! Thanks Bernie. You solved my problem.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Dynamically changing color of the last bar in a bar chart

    Great - thanks for letting me know.

    B

+ 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. [SOLVED] changing userform label control's color dynamically
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2014, 02:26 AM
  2. Dynamically changing where a chart's data comes from
    By Chimpy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-27-2013, 10:04 AM
  3. Changing Font Color of Dynamically created CheckBoxes
    By craigba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2011, 07:17 AM
  4. Dynamically changing the series of chart
    By bhokalivarun in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-25-2009, 04:02 AM
  5. Dynamically changing chart
    By penny in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2007, 10:19 AM

Tags for this Thread

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