+ Reply to Thread
Results 1 to 2 of 2

Gantt Diagram and conditional layout

  1. #1
    Registered User
    Join Date
    01-06-2023
    Location
    Paris
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Question Gantt Diagram and conditional layout

    Hello everyone,

    I need to put different colours on Gantt bars depending on the value written in the C column (Archi), PC, AQ or CO

    Does anyone can help me with that please ?

    Attached the excel file.

    Thank you very much !
    Diagramme de Gantt simple2.xlsx
    Last edited by Beam75; 01-06-2023 at 01:51 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Gantt Diagram and conditional layout

    If you mean to have three colors, then, for PC:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

+ 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. Conditional Formatting for GANTT
    By rz6657 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2022, 07:28 PM
  2. Gantt diagram
    By ifomin in forum Excel General
    Replies: 1
    Last Post: 01-23-2022, 09:37 AM
  3. VBA- Copy cells incl. Diagram and update diagram reference
    By Julian91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2018, 07:03 PM
  4. Somehow the layout of every diagram I open is broken
    By Sydneyfox in forum Excel General
    Replies: 0
    Last Post: 11-25-2015, 09:24 AM
  5. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  6. Conditional Functions for Gantt Chart
    By mycon73 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-22-2011, 03:19 PM
  7. conditional layout
    By PANCAKE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2007, 06:04 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