+ Reply to Thread
Results 1 to 8 of 8

Advice on how to present large amounts of data in a better way

  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Advice on how to present large amounts of data in a better way

    Hello there!
    As I'm not an everyday user of Excel charts, I'm not the most skilled person to be creating charts in Excel. However, I'm facing writing an analysis at the moment, so illustrations would do well to accompany the text.
    What I basically have is a dataset measuring labor productivity among other productivity ratios. Whatever the indicator, it consists of data from the past seven years (2007-2013). But most importantly, the data is distinguished regionally (four different regions) and the size of firm it represents (three size categories). So that's an 80+ dataset (see attachment).
    What you'll also find in the file is a botched attempt at trying to display the data. Not a very representative chart, as you'll quickly realize! So anyone got any good ideas how to make the dynamics of regional tendencies more apparent? Ideally, it should help visualize the data year-on-year either by direct comparison of regions or the size of companies. Any way to do that?
    I suppose I could leave out the years inbetween, but I really wouldn't want to do that as it's the changes that should stick out.

    Sorry about the clumsiness! But find in yourself to help even the most dim-witted.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Advice on how to present large amounts of data in a better way

    Maybe like this?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-07-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Advice on how to present large amounts of data in a better way

    Cheers! That is much better indeed!
    Though I still can't quite figure out where the data for one region's medium-sized and large enterprises has disappeared. But thanks for the effort!

    Now if anyone still has some ideas, please do contribute! As I have many similar sets of data to prepare for the business report, I'm open to all ideas¡ Sorry I can't return the favor, folks!

  4. #4
    Registered User
    Join Date
    05-07-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Advice on how to present large amounts of data in a better way

    Quote Originally Posted by oeldere View Post
    Maybe like this?
    By the way, how come some of the data for the SE region has gone missing? No values displaying for small and middle-sized firms? smiley-confused002.gif

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Advice on how to present large amounts of data in a better way

    Please Login or Register  to view this content.
    which one are missing?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Advice on how to present large amounts of data in a better way

    Check the source table Output!A1:D85.

    The Region name at rows 12 and 13 are incorrect. I assume a simple copy/paste problem.
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    05-07-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Advice on how to present large amounts of data in a better way

    Yeah, thanks for that. Got it.

    By the way, how can data be resorted in a suitable way? I mean, here it can be sorted alphabetically and descending (small-medium-large) but in other cases (such as months) sorting alphabetically makes no sense at all. So how do you make data (such as months or anything that logically shouldn't be in alphabetical order) appear in a certain way? As Pivot tables seems to put all text in alphabetical order...

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Advice on how to present large amounts of data in a better way

    use numbers instead of tekst. (e.g. 01, 02 ,03 etc).

    Make sure you format it in 00.

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Advice on how to present large amounts of data in a better way


+ 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. Help Transposing Large Amounts of Data
    By NFT86 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-11-2014, 06:05 PM
  2. Averaging large amounts of data
    By clarson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2013, 02:11 PM
  3. Excel 2007 : Filtering large amounts of data
    By as1508 in forum Excel General
    Replies: 9
    Last Post: 05-22-2012, 12:40 PM
  4. Large Amounts of Data
    By Drewser33 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2008, 09:13 AM
  5. Doing Analysis from large amounts of DATA
    By william4444 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-15-2006, 04:01 AM

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