+ Reply to Thread
Results 1 to 2 of 2

Different color for chart bars, for mondays

  1. 12-10-2023, 04:53 PM #1
    cyberuser
    cyberuser is offline
    Registered User
    Join Date
    10-25-2006
    Posts
    48

    Different color for chart bars, for mondays

    Good day !

    I have a chart that has dates in the X axis.
    All bars with their values are blue.

    Is there a way to paint all Mondays as red thru VB script ?

    Thanks !
    Reply With QuoteRegister To Reply
  2. 12-10-2023, 06:34 PM #2
    kaasplankje
    kaasplankje is offline
    Forum Contributor
    Join Date
    11-23-2022
    Location
    Amsterdam
    MS-Off Ver
    2021
    Posts
    193

    Re: Different color for chart bars, for mondays

    Please record a macro and then change the graph manually. Then check the recorded code to see what code you need in your macro.

    https://support.microsoft.com/en-gb/...5-3ea70e64937b
    Last edited by kaasplankje; 12-10-2023 at 06:36 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A macro that changes the color of the bars in the chart
    By samko78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2019, 03:55 PM
  2. Changing the color of the bars in a Gantt chart based on a value
    By jeannelacombe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2018, 04:28 PM
  3. [SOLVED] Automatically color bars in chart based on color in cell
    By D-smoke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2018, 04:10 AM
  4. Dynamically Changing the Color of Bars in the Chart
    By TimeHack11 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-12-2017, 11:25 AM
  5. VBA to change color of bars in a pivot chart
    By seanpod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2017, 10:20 AM
  6. 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
  7. how to change color of bars in bar chart based on 2nd variable
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2010, 09:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1