excel question

Society Business and Career
1

I have 2 data series

one is number of people
second is the salary range

what is the best way to make a graph that shows the distribution. I am trying diff options and not really happy with what I am seeing. any ideas?

2

Re: excel question

distribution.

Try to merge and pivot table it..
and then pie chart maybe?

3

Re: excel question

Fraudz,

may be try inputting frequency bins (depending on how many salary ranges you wanna have), and then use the frequency function. Finally, use the bar chart to depict the data as a histogram. To have a bar chart look like a legit histogram, make sure you set the gap width to zero.

That's the simplest way that I'd do it based on what little you said.