+ Reply to Thread
Results 1 to 6 of 6

Bar Graph - Compare Budget to Actual

  1. #1
    Registered User
    Join Date
    11-22-2011
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question Bar Graph - Compare Budget to Actual

    I have a worksheet on the last page of my workbook that keeps track of all the hours worked in different categories, and it has a place for the budget hours that should have been worked. I would like to keep a bar graph on the last page, comparing budget to actual. Most importantly, I would only like those categories that actually have entries made on them to show up on the chart, in order to cut down on clutter and make it easier to read. Any suggestions on how to have the entire data set selected, but to just get the ones with numbers to show up on the graph? Any suggestions on how to make an actual vs. budget bar graph look really professional and easy to read?

  2. #2
    Registered User
    Join Date
    11-03-2011
    Location
    Shelton, CT
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Bar Graph - Compare Budget to Actual

    Hi, There are many ways. Can you post an example so we can assure the chart captures YOUR data properly. You can use dummy values and dummy titles, just so that layout and cell contents are the same.

  3. #3
    Registered User
    Join Date
    11-22-2011
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Bar Graph - Compare Budget to Actual

    This is the spreadsheet that will be used for each client. This is what it will look like to start, and as work is done, the time spent will be filled in. The first four sheets are by week, and the last sheet keeps a running total of time spent by category. So, what I was wanting to do, was keep a chart comparing the budget to actual time spent on the last sheet. What I was really hoping for was to only get those categories that actually have time spent on them. I would like to have it already set up so the user (me or other employees) won't have to do anything except make entries in the description columns on the other sheets.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-03-2011
    Location
    Shelton, CT
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Bar Graph - Compare Budget to Actual

    Hi again,

    Can you unprotect your document? Since you are auto calculating time based on the next entry, I have no way of putting in data to test unless I wait a LONG TIME

  5. #5
    Registered User
    Join Date
    11-22-2011
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Bar Graph - Compare Budget to Actual

    Here's the unprotected one. The only reason it was protected was because some people that were using it here in the office tried to manually enter the end time and it caused errors due to formatting differences.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-22-2011
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Bar Graph - Compare Budget to Actual


+ 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