531joshua Posted October 4, 2009 Report Share Posted October 4, 2009 Hi allI don't post on here a lot but I'm aware that there are some computer-literate folks using the forum? Anyway... basically I've got this histogram I need to do for a school project but despite spending over 4 hours on it, I can't get my head round how it works. The situation is... there are three diciplines within a company ("Cost Management", "Planning" and "Procurement") - over a given period of time, a trainee within the company would spend a set amount of time studying each dicipline. I need to have a histogram showing this. I've made something in paint to resemble roughly what I'm trying to achieve. The trainee would spend 6 months in each dicipline, starting from Nov-09 onwards.Like I've said, I've fiddled on with excel for well over 4 hours and can't get my head around how to do this, I've laid the data out several ways and tried using different chart types and what not, but just can't get the result I'm looking for. If anyone can help me out it would be much appreciated!Josh. Quote Link to comment Share on other sites More sharing options...
tomturd Posted October 4, 2009 Report Share Posted October 4, 2009 I'd have thought you'd use a gantt chart for that (exactly what you've done, just on its side, with dates across the top, tasks down the side). A histogram (fancy word for bar chart?) seems a bit of an odd choice - not really suited to what you want. Quote Link to comment Share on other sites More sharing options...
Revolver Posted October 4, 2009 Report Share Posted October 4, 2009 (edited) A histogram (fancy word for bar chart?)A histogram works differently to a bar-chart. With a histogram, the width and the height are both factors. I can't remember exactly what they do now though We're talking 4 years ago, when I last drew one of those f**kers.Proportion, that's what it shows... Edited October 4, 2009 by Revolver Quote Link to comment Share on other sites More sharing options...
ManxTrialSpaz Posted October 4, 2009 Report Share Posted October 4, 2009 Yeah, a Gantt chart would seem more appropriate, and easy enough to mock up in Excel as well.And a histogram is just a bar chart but they take the area of the bar into account instead of just the height. So they can be used to show data from groups of uneven width and then you can work out stuff about the spread of data etc. Quote Link to comment Share on other sites More sharing options...
Tomm Posted October 5, 2009 Report Share Posted October 5, 2009 A histogram works differently to a bar-chart. With a histogram, the width and the height are both factors. I can't remember exactly what they do now though We're talking 4 years ago, when I last drew one of those f**kers.Proportion, that's what it shows...You typically use histograms for continuous variables - E.g. an age range. 10-15, 16-20, 21-30, 31-80 or something - particularly where the age range is wider depending on which age group you fall into. Quote Link to comment Share on other sites More sharing options...
tomturd Posted October 5, 2009 Report Share Posted October 5, 2009 Ah.. ok not just a fancy bar chart then it's been about.. 10 years I guess Quote Link to comment Share on other sites More sharing options...
Tomm Posted October 5, 2009 Report Share Posted October 5, 2009 I do bar charts histograms for fun! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.