Histograms

[1heng]

I've figured how to get the histogram chart up.
Tools > Add Ins > Analysis Toolpack.
This allows you to chart histograms. I have now encountered a new problem; i want to display the company names on the x - axis (horizontal) and their corresponding values along the y -axis (vertical). I have attached some SS to show what the histogram pop up looks like.
I don't understand where do i input my values to get my final result.
What is Bin Range? What is Input Range?

Thanks in advance

[sweep]

Hi,

To plot the data table you have attached, you need a bar graph, not a histogram.

A histogram is a graphical representation of frequencies.

The excel function to generate a function needs a list of frequencies (the input range) and a set of categories wthin which the frequencies will fall (the bin range)