+ Reply to Thread
Results 1 to 2 of 2

Help to produce a chart with large data set

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Help to produce a chart with large data set

    Hi Everyone
    I was wondering whether someone can help me with an advise on the best way to draw a chrt.

    I have attacahed a very simple file to illustrate my problem.

    I have a very large data set, over 165k of rows. the spreadsheet has information of sales per sales person for each month. When i draw a graph as its large it doesnt make any sense as its not clear because of the amount of x-axis label.

    In the sample spreadsheet I have attached it does show a problem I have.Can someone please tell me what will it be the best way in the attached sheet to present a meaningful and readable graph to show the sales person sales for each region for each month. it can be any suitable chart. the chart in sheet 1 is the one i am interested in

    Thanks in advane
    Attached Files Attached Files
    Last edited by rv02; 05-27-2018 at 04:54 PM. Reason: explanation to make it clearer

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Help to produce a chart with large data set

    I'm not sure that any type of chart will make that much information in one place particularly meaningful.

    Personally I would go for two charts.

    One that shows a Region breakdown (with your stated version of Excel this will allow you to easily filter the chart to show single/multiple regions for an even clearer picture) and another dynamic chart that shows each salesperson for a selected region, or all salespersons and again you use the chart filters if you want a more select view of just a handful of them.

    BSB

+ 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. Unable to produce league table/chart based on data
    By chrisellis250 in forum Excel General
    Replies: 4
    Last Post: 10-06-2016, 12:01 PM
  2. [SOLVED] Re-produce chart
    By Villalobos in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-09-2016, 05:19 AM
  3. Produce Chart from Data
    By andihawes in forum Excel General
    Replies: 1
    Last Post: 04-19-2012, 03:37 PM
  4. Better chart labelers for large sets of data? (using TM currently)
    By woontime in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-04-2011, 02:25 AM
  5. Chart only a part of a large data set
    By delboy2405 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-24-2008, 05:03 AM
  6. row data too large - cannot graph gantt chart
    By Aussie1497 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-02-2005, 04:47 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