+ Reply to Thread
Results 1 to 3 of 3

Need help charting Multi-dimensional data

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Question Need help charting Multi-dimensional data

    Hello,

    I would appreciate any suggestions on creating a chart for the following:

    For a project, I receive Hours utilized and work completed. Both of these are a percentage where hours being a percentage of estimated vs actual hours. On a weekly basis, I receive these two figures from development and from QA for 4 different (related) tasks. I would like to show progress week on week for each task and for both QA and dev for each of the percentages.

    Data table looks like this:

    excel Table.png

    Updates always come in pairs so I always have two rows for each week.

    Ideally, I would want a single chart for this. If needed I am to multiple; Open to suggestions.

    Thank you very much.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Need help charting Multi-dimensional data

    If you convert your data range to an Excel table and then build your chart off the Excel Table, as you add new data each week, the chart will expand automatically to reflect the new data.

    Here is something to get you started with tables: http://www.utteraccess.com/wiki/Tables_in_Excel.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    07-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Need help charting Multi-dimensional data

    Thank you.

+ 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. Is there a simple way or chart to represent multi dimensional data?
    By sreenire in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-04-2012, 11:01 AM
  2. Replies: 0
    Last Post: 04-16-2012, 07:43 PM
  3. [SOLVED] append multiple worksheets data to a single multi-dimensional array
    By junoon in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 04-10-2012, 02:28 PM
  4. Multi-dimensional data input and reporting
    By HGL1234 in forum Excel General
    Replies: 8
    Last Post: 03-02-2012, 06:49 AM
  5. Charting multi-level data
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-09-2009, 07:34 PM
  6. Multi-sheet data charting problem
    By Jim M in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2005, 09:06 PM

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