Histogram
 

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

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

Histogram
 

Thank you for reply.

I need to build a graph of type
http://alea-estp.ine.pt/html/nocoes/...o3_2_31_2.html

an


"Mike Middleton" wrote:

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


.

Histogram
 

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


"an" wrote in message
...
Thank you for reply.

I need to build a graph of type
http://alea-estp.ine.pt/html/nocoes/...o3_2_31_2.html

an


"Mike Middleton" wrote:

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


.

Histogram
 

M Middleton,

Many thanks!
an

"Mike Middleton" wrote:

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


"an" wrote in message
...
Thank you for reply.

I need to build a graph of type
http://alea-estp.ine.pt/html/nocoes/...o3_2_31_2.html

an


"Mike Middleton" wrote:

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


.

.