Forum Discussion

John_EHDS's avatar
John_EHDS
Copper Contributor
Jul 29, 2022

gantt charts

Hi All

 We have a simple Gantt chart that I downloaded,  We plan our jobs on the chart based on start and end dates. We choose the start date based on the availability of staff,

We would like to be able to colour the columns based on the dates that staff are available to help us plan the jobs.

We can do this manually but when we change the date range the colours do not move with the dates.

So Im sure this is simple I just don't know how to do it.

So simply, I want the colours to move with the columns associated with the dates so that when we change the date range the coloured columns move with the dates.

I hope this makes sense, I can send you a copy of the blank chart if you need it

Thanks in advance to any one who can help with this.

Excel
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Aug 01, 2022

    Hi John_EHDS 

     

    yes, this could usually be solved with conditional formatting. If you would upload your file (without any sensitive data, just with some example data), then we can give a more precise advice.

    • JohnEHDS's avatar
      JohnEHDS
      Copper Contributor
      Aug 01, 2022

      Martin_Weiss 

      Hi Martin.

      Thanks for getting back to me.

      I can upload a copy of the Gantt chart I downloaded, with a copy of what we want it to look like

      Do you know hi I can attach the files?

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Aug 01, 2022

        JohnEHDS 

        When you compose a reply, you may see an area below the space where you type labeled "Drag and drop here or browse files to attach".

        If you don't see that, you can upload your sample workbook to a cloud store such as OneDrive, Google Drive, Dropbox, then obtain a link to the uploaded file and post that link in a reply.

        You can also send Martin a Private Message and attach the workbook to the message.

Share