Gantt charts for scheduling

Hi Ram8516,

Welcome to the forums.

I would recommend putting your data into a different format.

I used this tutorial and modified it for multiple tasks in the attachment.
How-to Make a Weekly 24 Hour Time Worked Gantt Chart in Excel

TimeGanttChart-MultiTask.xlsx

I can try and modify your data late tonight, but does this help? Let me know.

Steve=True

Hi Ram8516,

Here is my solution to your question.

Here is the file: Gantt by Project by Machine.xlsx

This uses Gantt Charts (see the like I posted above) as well as multi-level category axis'. You can learn more about multi-level categories here:

How-to Easily Create a Stacked Clustered Column Chart in Excel


Steve=True

hi

unfortunately we need to do something else to get this.

How-to Add Custom Labels that Dynamically Change in Excel Charts

Let me know if this helps

Steve=True

hi

unfortunately we need to do something else to get this.

How-to Add Custom Labels that Dynamically Change in Excel Charts

Let me know if this helps

Steve=True

Hi Steve,

Got the method. I am trying to add multiple custom labels. using =cell ref1, cell ref2. It does not work. any thoughts.

Thank you,
Regards
Ram

Originally Posted by Steve=True

hi

unfortunately we need to do something else to get this.

How-to Add Custom Labels that Dynamically Change in Excel Charts

Let me know if this helps

Steve=True

Hi Ram,

Are you trying to do something like this?

Add Multiple Percentages Above Column Chart or Stacked Column Chart

Let me know.

Thanks

Steve=True