+ Reply to Thread
Results 1 to 4 of 4

Trying to make a chart

  1. #1
    Registered User
    Join Date
    03-05-2008
    Location
    Ontario, Canada
    MS-Off Ver
    2010 Pro Plus
    Posts
    78

    Trying to make a chart

    Ok so ive got a worksheet, that shows how much work I've done monthly.

    There are 12 tabs (jan - Dec) as well as a "Totals" tab.

    The totals is where im keeping a running total of work ive done, including this chart.

    I cant get a chart setup to show the month along the bottom, and the numbers along the side.

    The side numbers would have to go to about 100.

    Each of my tabs has a Totals row, that shows how many items ive produced each month.

    How do i apply this to a chart? When i create a chart, and select each of the "Totals" rows each month it tells me the data is invalid.

    I just want a basic line chart.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482
    Can you post small example of what you have.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-05-2008
    Location
    Ontario, Canada
    MS-Off Ver
    2010 Pro Plus
    Posts
    78
    Here is the actual spreadsheet itself.
    There is no confidential data, just a bunch of names and numbers really.
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482
    You will need to create a chartable range on the Totals sheet in order to get a meaningful chart.
    Attached Files Attached Files

+ 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