+ Reply to Thread
Results 1 to 1 of 1

Fit text in bar chart and change bar colors

  1. #1
    Registered User
    Join Date
    07-27-2024
    Location
    Madrid, Spain
    MS-Off Ver
    Microsoft Office365
    Posts
    3

    Fit text in bar chart and change bar colors

    Hi Everyone,

    I have this timeline chart of different failures that affected the performance of a car, I made the chart using PeltierTech's "Easier gantt chart for repeated tasks". There are three places where failures happen so I grouped them with colors (see image), but in order to make the chart easier to understand I want to paint the bars with the according colors and not use boxes. Note that the grey boxes are only to make spaces and separate the grouped failures, is there a way to use 3 sets of data for this? I can't mannually paint them since the failures change weekly and I'd have to repaint manually every week.

    Also, there are labels in the bars that help my find out about what type of failure happened, but they don't always fit the length of the bar and I really don't want to make the text smaller, does anyone know how to help me with fiiting the text?

    Also I'd like to add informative vertical axis labels according to PeltierTech, but can't do it since I've already used my secondary axis.

    If anyone knows how to attack any of this issues please let me know.

    Thanks,

    Felipe.
    Attached Images Attached Images
    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. [SOLVED] VBA code to change Excel chart bar colors as per cell colors
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2016, 03:29 AM
  2. Change bar colors in chart
    By vibhor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2015, 08:53 AM
  3. Change colors on bar chart
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2015, 03:11 PM
  4. 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
  5. Replies: 0
    Last Post: 08-07-2012, 03:54 PM
  6. Change Chart Bar or other Colors
    By sachinattri in forum Excel General
    Replies: 0
    Last Post: 03-24-2006, 07:36 AM
  7. [SOLVED] who do i conditionally change bar chart colors?
    By Sid N in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-13-2005, 03:05 PM

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