Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Chart Or Graph For Room Assignment

  1. #1
    Join Date
    29th September 2007
    Posts
    2

    Chart Or Graph For Room Assignment

    Hi Excel Experts!

    I have an Excel sheet I use for Schedule of classes. In that sheet I have many columns like Subject, Section, Attempt, Starting Date and so on.

    However only four columns are relevant to my question. (Please see the attached file, I have shown data in the attached file in only those relevant columns).

    I want to make two seperate sheets (or charts) to show the usage of rooms assinged to different classes. Some classes are to be held on first three days of the week i-e Mon, Tue and Wed and some on last three days i-e Thr, Fri and Sat.

    I want to setup two seperate sheets (or charts) which will show me the usage of rooms.

    Please see the attached file for better understanding of my problem. I have highlighted the cells in sheet named Mon-Tue-Wed for the usage of Room 1 only.

    I have found a link of web which may be modified to adjust to my problem. Here is that link.

    http://www.lacher.com/examples/lacher24.htm

    I have also posted this question at
    http://www.excelforum.com/showthread.php?p=1832726
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Chart To Show Room Assignment

    User3, Welcome to OZgrid.

    It seems to me you have the very answer you need with the example from Lacher's link.
    Have you made any effort to adapt this to your situation?

    See this thread: VBA Color Cells for Gannt Chart

    Also: Gantt Charts - John Peltier

    Search using these terms:
    Excel Gannt Chart With Sliding Time Scale see thread: 60623

    Custom Schedule - Gantt Chart see thread: 12824

    HTH,
    AAE
    Last edited by AAE; September 30th, 2007 at 11:48. Reason: correct hyperlink

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    29th September 2007
    Posts
    2

    Re: Chart To Show Room Assignment

    Quote Originally Posted by AAE
    User3, Welcome to OZgrid.

    It seems to me you have the very answer you need with the example from Lacher's link.
    Have you made any effort to adapt this to your situation?

    See this thread: VBA Color Cells for Gannt Chart

    Also: Gantt Charts - John Peltier

    Search using these terms:
    Excel Gannt Chart With Sliding Time Scale see thread: 60623

    Custom Schedule - Gantt Chart see thread: 12824

    HTH,
    AAE
    Hi AAE thank you so much for your response.
    Infact I am not expert of VBA (coding) and I don't know how to modify the code. I will be grateful to you if you put the code in the attached file with proper modifications.

    (One more thing which I missed to mention in previous post that I am using Excel 2007)

    Thank you for your help and spending time to solve my problem.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Waterfall Chart/Graph
    By kdog in forum EXCEL HELP
    Replies: 1
    Last Post: August 3rd, 2008, 08:17
  2. Gantt Chart/Graph
    By Dave Hawley in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 1
    Last Post: May 15th, 2008, 17:39
  3. Rotate Chart/Graph
    By tbone_111 in forum EXCEL HELP
    Replies: 2
    Last Post: April 23rd, 2008, 17:53
  4. Graph-Chart In Cell
    By macrosoft in forum EXCEL HELP
    Replies: 3
    Last Post: December 18th, 2006, 17:15
  5. Image box in Graph/Chart
    By cweaver in forum EXCEL HELP
    Replies: 3
    Last Post: February 4th, 2006, 02:50

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
  •  
porno