Histogram

  • Thread starter Thread starter an
  • Start date Start date
A

an

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
 
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 -

You could create such a chart using Excel by using the XY (Scatter) chart
type, either by having two (x,y) pairs for the vertical bars or by using
error bars.

Excel chart guru Jon Peltier has instructions for "Step Charts in Microsoft
Excel" at
http://peltiertech.com/Excel/ChartsHowTo/StepChart.html

There may be other sources that you could find by searching (Google, Bing,
etc.) for "Excel step chart" (without the quotes).

- Mike
http://www.MikeMiddleton.com
 
M Middleton,

Many thanks!
an

Mike Middleton said:
an -

You could create such a chart using Excel by using the XY (Scatter) chart
type, either by having two (x,y) pairs for the vertical bars or by using
error bars.

Excel chart guru Jon Peltier has instructions for "Step Charts in Microsoft
Excel" at
http://peltiertech.com/Excel/ChartsHowTo/StepChart.html

There may be other sources that you could find by searching (Google, Bing,
etc.) for "Excel step chart" (without the quotes).

- Mike
http://www.MikeMiddleton.com



.
Click to expand...
 
Back
Top