Help to produce a chart with large data set
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
Last edited by rv02; 05-27-2018 at 04:54 PM.
Reason: explanation to make it clearer
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By chrisellis250 in forum Excel General
Last Post: 10-06-2016, 12:01 PM
By Villalobos in forum Excel Charting & Pivots
Last Post: 07-09-2016, 05:19 AM
By andihawes in forum Excel General
Last Post: 04-19-2012, 03:37 PM
By woontime in forum Excel Charting & Pivots
Last Post: 08-04-2011, 02:25 AM
By delboy2405 in forum Excel Charting & Pivots
Last Post: 12-24-2008, 05:03 AM
By Aussie1497 in forum Excel Charting & Pivots
Last Post: 03-02-2005, 04:47 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1