+ Reply to Thread
Results 1 to 4 of 4

How to create chart for an action (time specific) along the month

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Question How to create chart for an action (time specific) along the month

    i work for a pharmaceutical company. Please help me draw a graph.

    For a given reactor, if batch reaction time is "x hrs" and it will keep continuing all along the days may be for "y hrs" also.

    Plot a graph with "date" on X-Axis and batch reaction time ( x hrs or y hrs) along the length of X-Axis

    Attached is how i want a graph drawn manually.graph.jpg

    TIA

    Cross-post link: https://www.mrexcel.com/board/thread...month.1133161/
    Last edited by Paul; 05-06-2020 at 02:17 AM. Reason: Adding cross-post link from other site

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,502

    Re: How to create chart for an action (time specific) along the month

    Hello kvmadiri and Welcome to Excel Forum.
    Attached is a data arrangement and Gantt char that may help get the ball rolling.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    05-06-2020
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Re: How to create chart for an action (time specific) along the month

    thank you very much for your support,
    But this format is not the one i need.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,499

    Re: How to create chart for an action (time specific) along the month

    What is it about JeteMc's example that is unsuitable? Can you not use the "in cell charting" conditional formatting technique that he used -- or is there something else about his example that you don't like?

    If it is the in cell charting technique that you don't like, and you would prefer a "real" chart. As JeteMc notes, your picture looks like a Gantt chart. When we don't use in cell charting/conditional formatting to do Gantt charts, they are created as stacked bar charts. Basically, you will need to enter/compute your start date/time and the duration for each "stack" of the stacked bar, then arrange that data in a way that will be easy to work with, then create and format a stacked bar chart from the duration data. This discussion has an example: https://www.excelforum.com/excel-cha...cel-chart.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] Create a column chart by month with three separate contributors?
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-05-2016, 08:35 PM
  2. [SOLVED] create specific event at specific time every week
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 47
    Last Post: 08-04-2016, 03:42 PM
  3. Create a chart from pivot with a specific type of lay out for chart
    By excelas88 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-08-2015, 03:03 PM
  4. Replies: 2
    Last Post: 03-06-2015, 03:45 PM
  5. Create 12 month rolling chart
    By bberger1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2013, 12:24 PM
  6. Replies: 2
    Last Post: 09-16-2013, 05:17 AM
  7. Replies: 0
    Last Post: 09-12-2013, 10:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1