|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 11th, 2010, 01:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
May 11th, 2010, 07:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 news  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
|
|
#3
May 13th, 2010, 07:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 news 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 .
|
|
#4
May 14th, 2010, 03:32 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 news 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 .
|
|
#5
May 14th, 2010, 02:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 news
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 . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
