How do you create a histogram in excel when you have the following data on 40 best paid executives:
rank (1-40), CEO (name), Company (name), Salary, Age, Degree (type: none, bachelors, Law, MBA, PhD, masters)
Which is the input range and which is the bin range? I'm confused as to which data to use that provides a visual representation of the data pertaining to executive salaries.