http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Fri, 24 May 2013 19:38:04 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20276 Wed, 07 Mar 2012 20:34:15 +0000 hitmanwa 20276@http://chandoo.org/forums/ <p>Here ya go...</p> <p><a href="https://docs.google.com/open?id=0B68LsAWKQ7W7SGJEMk9DRUxUOVM2UFBWMEdkUXkwQQ" rel="nofollow">https://docs.google.com/open?id=0B68LsAWKQ7W7SGJEMk9DRUxUOVM2UFBWMEdkUXkwQQ</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20267 Wed, 07 Mar 2012 17:40:40 +0000 xcruc1at3r 20267@http://chandoo.org/forums/ <p>pls load the File on Doc.google pls so we all can get help from it...<br /> as i can only access doc. google due to office restrictions </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20164 Tue, 06 Mar 2012 15:30:22 +0000 hitmanwa 20164@http://chandoo.org/forums/ <p>Thanks all,</p> <p>Here's an unprotected copy, I probably could have tightened it up a bit as far as the code and how everything is calculated and compiled but I'm still learning some of this.</p> <p><a href="http://dl.dropbox.com/u/65191455/Efficiencies.xlsm" rel="nofollow">http://dl.dropbox.com/u/65191455/Efficiencies.xlsm</a></p> <p>You won't be able to update it because it pulls the data from 4 other files located on our network.</p> <p>I didn't use sparklines, I wanted to, because some of our associates aren't on 2010 and my understanding is they don't show up on versions prior to 2010.</p> <p>Thanks all, </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20162 Tue, 06 Mar 2012 15:03:28 +0000 Hui 20162@http://chandoo.org/forums/ <p>Faseeh<br /> The last chart style post chandoo made was:<br /> 3 days ago: <a href="http://chandoo.org/forums/topic/floating-camera-tool-picture" rel="nofollow">http://chandoo.org/forums/topic/floating-camera-tool-picture</a><br /> 3 weeks ago: <a href="http://chandoo.org/forums/topic/making-different-excel-charts-on-the-same-scale" rel="nofollow">http://chandoo.org/forums/topic/making-different-excel-charts-on-the-same-scale</a></p> <p>Chandoo often refers to Jon Peltiers web site : <a href="http://peltiertech.com/" rel="nofollow">http://peltiertech.com/</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20157 Tue, 06 Mar 2012 14:36:25 +0000 Faseeh 20157@http://chandoo.org/forums/ <p>Hui,</p> <p>I can recall that few days back chandoo refereed how to make charts better and he refereed to some other site. I have tried searching for that post but am unable to locate it. I can remember one of the points: 'De-emphasize borders'. Can you locate the post. It might help hitmanwa. </p> <p>Thanks,<br /> Faseeh </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20156 Tue, 06 Mar 2012 14:29:38 +0000 Hui 20156@http://chandoo.org/forums/ <p>@Hitmanwa</p> <p>and the sheet is also protected </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20152 Tue, 06 Mar 2012 14:19:38 +0000 Faseeh 20152@http://chandoo.org/forums/ <p>Thanks Hui! :)</p> <p>@ hitmanwa,</p> <p>Your last chart looks great, but when i try to change the dates from drop-down on top left, i goes to searching for some file and asks to open it? Perhaps it might be due to some linkage to file on your HD or so, overall it looks cool. </p> <p>Regards,<br /> Faseeh </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop/page/2#post-20147 Tue, 06 Mar 2012 13:00:52 +0000 Hui 20147@http://chandoo.org/forums/ <p>Feseeh, </p> <p>Thats a neat and professional looking Chart</p> <p>Hui... </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20146 Tue, 06 Mar 2012 12:57:34 +0000 Hui 20146@http://chandoo.org/forums/ <p>Aratrika</p> <p>Please start a new threads for new questions which are unrelated to this thread</p> <p>With regards pivot tables refer here: <a href="http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/" rel="nofollow">http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20145 Tue, 06 Mar 2012 12:57:09 +0000 dan_l 20145@http://chandoo.org/forums/ <p>Ahhh there' you go hitman. You're getting there. </p> <p>Man, chandoo should do a post about this...</p> <p>Aratrika: we'll help with whatever you want. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20144 Tue, 06 Mar 2012 12:41:41 +0000 aratrika 20144@http://chandoo.org/forums/ <p>Can any body help me to learn pivot table and dash board in simple version since my intelligence level is just average. </p> <p>Thanks &amp; regards</p> <p>aratrika </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20138 Tue, 06 Mar 2012 10:08:22 +0000 Faseeh 20138@http://chandoo.org/forums/ <p>Hi hitmanwa,</p> <p>I have tried to do something using 'Spark Lines', the graph produced is simple yet attractive. Please see the attached file. (If you can't see the graph line resort to the last sheet that has a screen shot of the same). I hope you will like it!!</p> <p><a href="http://dl.dropbox.com/u/60644346/EffSample_Reworked.xlsx" rel="nofollow">http://dl.dropbox.com/u/60644346/EffSample_Reworked.xlsx</a></p> <p>Regards,<br /> Faseeh </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20124 Tue, 06 Mar 2012 04:04:35 +0000 hitmanwa 20124@http://chandoo.org/forums/ <p>This is what I ended up with in the end, I appreciate all the help. The bullet chart might be a bit big but I was filling space until I thought of something else to add.</p> <p><a href="http://dl.dropbox.com/u/65191455/Final.xlsm" rel="nofollow">http://dl.dropbox.com/u/65191455/Final.xlsm</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20028 Sat, 03 Mar 2012 19:06:13 +0000 hitmanwa 20028@http://chandoo.org/forums/ <p>K, done...it does look better. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20027 Sat, 03 Mar 2012 19:02:15 +0000 dan_l 20027@http://chandoo.org/forums/ <p>I would seriously avoid the axis at 80%. It really doesn't do what you think it does. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20026 Sat, 03 Mar 2012 18:37:56 +0000 hitmanwa 20026@http://chandoo.org/forums/ <p>Thanks Sir,</p> <p>Still playing around a bit with it. How's this look?</p> <p><a href="http://dl.dropbox.com/u/65191455/Latest.xlsx" rel="nofollow">http://dl.dropbox.com/u/65191455/Latest.xlsx</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20012 Sat, 03 Mar 2012 17:33:24 +0000 SirJB7 20012@http://chandoo.org/forums/ <p>Hi, hitwanma!<br /> Arriving at dessert-time and not being a chart specialist nor a chart lover and having seen all the chart variations proposed, my maybe your-audience-alike opinion is that the very first chart of all is still the most clear, easy and efficient.<br /> Just my another two-cents in comparison with the hundred of bucks of previous contributors.<br /> Regards! </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20006 Sat, 03 Mar 2012 16:45:16 +0000 hitmanwa 20006@http://chandoo.org/forums/ <p>The bullet chart's a good idea, hadn't thought of that. SfE are sparklines, right? </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20004 Sat, 03 Mar 2012 16:04:23 +0000 dan_l 20004@http://chandoo.org/forums/ <p>Good call. You might also appreciate using a something like SfE. That would let you do some really slick looking microcharts. </p> <p>And don't forget bullets!! </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20003 Sat, 03 Mar 2012 15:54:56 +0000 hitmanwa 20003@http://chandoo.org/forums/ <p>The conditionally formatted chart with the micro-chart. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20002 Sat, 03 Mar 2012 15:20:37 +0000 dan_l 20002@http://chandoo.org/forums/ <p>Ahk. </p> <p>I was going to say: unless your audience would understand the bell chart, don't use the bell chart:) </p> <p>So what will you be using for this? </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-20000 Sat, 03 Mar 2012 14:43:17 +0000 hitmanwa 20000@http://chandoo.org/forums/ <p>No, Managers and employees. A couple are engineers but that's it. I plan on using what I got from you to present to them but I was just playing with the bell chart for myself. I've always wondered how to make one in excel but it was just for me. I think I got it worked out, have to play with some of the bins and such and the "More" at the end of the Histogram throws the axis off but I'm just manually adjusting it. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19998 Sat, 03 Mar 2012 14:32:58 +0000 dan_l 19998@http://chandoo.org/forums/ <p>Hitman: </p> <p>Who's your audience in this case? Are they like engineers and such? </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19997 Sat, 03 Mar 2012 14:01:41 +0000 hitmanwa 19997@http://chandoo.org/forums/ <p>This is what I got with the bell curve. I'm not entirely sure I did it right. Why would I get values over 100%?</p> <p><a href="http://dl.dropbox.com/u/65191455/2.xlsx" rel="nofollow">http://dl.dropbox.com/u/65191455/2.xlsx</a> </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19987 Sat, 03 Mar 2012 07:36:01 +0000 NARAYANK991 19987@http://chandoo.org/forums/ <p>Hi ,</p> <p>The following link explains the bell chart :</p> <p><a href="http://support.microsoft.com/kb/213930" rel="nofollow">http://support.microsoft.com/kb/213930</a></p> <p>Narayan </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19983 Sat, 03 Mar 2012 05:40:06 +0000 hitmanwa 19983@http://chandoo.org/forums/ <p>That was a good read...I do tend to over think/complicate things. Thanks again, </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19982 Sat, 03 Mar 2012 05:35:01 +0000 dan_l 19982@http://chandoo.org/forums/ <p>Don't be embarrassed. Ok. I'll let you be embarrassed about the gradient color thing; but really that's for your own good so it's cool. </p> <p>Just a though: give a read to this. <a href="http://en.wikipedia.org/wiki/Chartjunk" rel="nofollow">http://en.wikipedia.org/wiki/Chartjunk</a></p> <p>Part of the trick is to go through each item on the chart and say "does this really need to be here?". In the case of the example above, I could see a reasonable argument that the formatting itself is rendered unnecessary because the target line is there. But, it I don't think that really takes away from the chart or makes it more difficult to read. </p> <p>clear as mud, yeah? </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19977 Sat, 03 Mar 2012 05:04:20 +0000 hitmanwa 19977@http://chandoo.org/forums/ <p>Thanks Dan, so easy I'm almost embarrassed. You are right, I was using 80% as the benchmark and should not have displayed it like that.</p> <p>Narayank, I'm look at the bell chart, I haven't done one in excel before but am curious to see what it looks like with this data.</p> <p>Thanks all, </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19974 Sat, 03 Mar 2012 04:53:31 +0000 dan_l 19974@http://chandoo.org/forums/ <p>Try this.<br /> <a href="http://dl.dropbox.com/u/1275899/EffSample-d.xlsx" rel="nofollow">http://dl.dropbox.com/u/1275899/EffSample-d.xlsx</a></p> <p>I'm sort of short on mental energy tonight, but if I'm understanding your correctly, those numbers are all positive. That's funny, because I think the chart had me searching for negative numbers, because that's the only reason I can think of to have the axis in the center. </p> <p>Maybe I'm totally confused. </p> http://chandoo.org/forums/topic/efficiency-chartlooking-for-some-pop#post-19971 Sat, 03 Mar 2012 04:43:39 +0000 NARAYANK991 19971@http://chandoo.org/forums/ <p>Hi ,</p> <p>OK. So the entire worksheet and chart is for only one department.</p> <p>Now , if you have the efficiency figures for each day , is it really necessary to chart the figures for each day ? Can you not chart only the exceptions ?</p> <p>A better way of showing a department's performance would be to have a bell chart , which will clearly highlight the outliers i.e. how spread out / inconsistent is the performance ? If the bell is very sharp , and there are very few outliers , it means that the department is focused and doing a good job of controlling inefficiency.</p> <p>Narayan </p>