+ Reply to Thread
Results 1 to 7 of 7

Need help plotting chart with various data

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    south UK
    MS-Off Ver
    Excel 2002
    Posts
    3

    Need help plotting chart with various data

    Hi there,
    I am new to this forum so sorry if I post something which has been discussed before.

    I need help creating a chart for times a certain computer was used. An example of the data is below:

    Machine Time available Time used
    A 9:00-15:45 9:00-10:00, 11:30-11:45 etc..
    B 9:00-15:45
    C 9:00-15:45
    D 9:00-15:45

    Ideally I would like a bar chart where the machine name is the Y axis and the times available are on the X axis (the times available will be plotted in half hour increments i.e 10-10:30, 11-11:30 etc) and the bar represents the times the machine was actually used, so there will be multiple "bits" of bar on each line.

    Is there a way of doing this?

    Thanks.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Need help plotting chart with various data

    You are using Excel 2002?
    Please click the * icon below if I have helped.

  3. #3
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Need help plotting chart with various data

    This will work if you have at least excel 2007.
    Rather than making a chart, formulas and conditional formatting should achieve what you are looking for.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    south UK
    MS-Off Ver
    Excel 2002
    Posts
    3

    Re: Need help plotting chart with various data

    Quote Originally Posted by Melvinrobb View Post
    You are using Excel 2002?
    Yes, it's a work project and excel 2002 is what we have installed on our machines, if it was up to me, it would be a later version

  5. #5
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Need help plotting chart with various data

    This version should work in 2002.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-26-2012
    Location
    south UK
    MS-Off Ver
    Excel 2002
    Posts
    3

    Re: Need help plotting chart with various data

    Quote Originally Posted by Melvinrobb View Post
    This version should work in 2002.
    Excellent, this is the sort of thing I was looking for. Just tweaked it a little bit

    Thank you.

  7. #7
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Need help plotting chart with various data

    Glad you found what you were looking for.
    Remember to changed this post to "solved" (under thread tools in the top right corner).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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