Thread: Histogram
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Histogram

an -

A histogram is typically a column chart (vertical bars) for a frequency
distribution. Since an Excel column chart has equally-spaced vertical bars,
the frequency distribution should use equal-width intervals. Those intervals
are usually specified by the inclusive upper bound of each interval (called
"bins" in Excel).

For more assistance, please explain your data. (For example, I note that 10
appears four times in column A and 0.0138 appears twice in column B.) Also,
explain what the chart should look like.

- Mike
http://www.MikeMiddleton.com



"an" wrote in message
...
Hi!

I have next:
A B
1 5 0,0138
2 9 0,015
3 4 0,0154
4 7 0,0136
5 10 0,0132
6 10 0,0158
7 10 0,0138
8 10 0,0089
9 35 0,0035

In a histogram, how can I increase the width of the column, based on the
x-axis values (Column A), please?

Thank in advance.
an