software

Trying to draw a histogram with various non equal age bands vs income,
neeed to do this as a histogram

Hi,

Enter the non-equal age-bands you want to use in a column.

quot;Toolsquot; --gt; quot;Data Analysisquot; --gt; quot;Histogramquot; --gt; quot;OKquot; --gt; select the range
containing the income data for quot;Input Rangequot; --gt; select the range containing
the non-equal age-bands for quot;Bin Rangequot; --gt; select a cell in an empty area
for quot;Output Rangequot; --gt; quot;OKquot;

Please note that the quot;Data Analysisquot; Add-in should have been installed in
Excel for this. You can also achieve the same results without using the
add-in, by using COUNTIF or SUMPRODUCT functions. If you need help please
reply to this post.

Regards,
B. R. Ramachandran

quot;HB 44quot; wrote:

gt; Trying to draw a histogram with various non equal age bands vs income,
gt; neeed to do this as a histogram

HB 44 -

gt; Trying to draw a histogram with various non equal age bands vs income,
gt; neeed to do this as a histogram lt;

You mention _two_ numerical variables: age and income. A histogram usually
displays frequencies for ranges of a _single_ numerical variable.

In Excel, a histogram usually is a Column chart type (vertical bars), and
each bar has the same width. The horizontal axis has equal-width ranges of
the numerical variable, and the frequency is shown by the height of the
vertical bar.

If you use the Histogram tool (Analysis ToolPak) and specify bin values that
are not equally-spaced, Excel will create the frequency distribution
correctly, but the Histogram chart will display equal-width bars
representing your unequal-width ranges, so the Histogram chart will be
distorted.

FunChrt5.zip is available from Stephen Bullen's Excel Page, showing a way to
get the appearance of unequal-width bars for a Column chart:

www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zipJon Peltier's Excel Chart Pages has general information about histograms:

peltiertech.com/Excel/Charts/Histograms.html

- Mike
www.mikemiddleton.com
Here are more links to variable width column charts:

peltiertech.com/Excel/ChartsH...thColumns.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Mike Middletonquot; gt; wrote in message
...
gt; HB 44 -
gt;
gt;gt; Trying to draw a histogram with various non equal age bands vs income,
gt;gt; neeed to do this as a histogram lt;
gt;
gt; You mention _two_ numerical variables: age and income. A histogram usually
gt; displays frequencies for ranges of a _single_ numerical variable.
gt;
gt; In Excel, a histogram usually is a Column chart type (vertical bars), and
gt; each bar has the same width. The horizontal axis has equal-width ranges of
gt; the numerical variable, and the frequency is shown by the height of the
gt; vertical bar.
gt;
gt; If you use the Histogram tool (Analysis ToolPak) and specify bin values
gt; that are not equally-spaced, Excel will create the frequency distribution
gt; correctly, but the Histogram chart will display equal-width bars
gt; representing your unequal-width ranges, so the Histogram chart will be
gt; distorted.
gt;
gt; FunChrt5.zip is available from Stephen Bullen's Excel Page, showing a way
gt; to get the appearance of unequal-width bars for a Column chart:
gt;
gt; www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zip
gt;
gt;
gt; Jon Peltier's Excel Chart Pages has general information about histograms:
gt;
gt; peltiertech.com/Excel/Charts/Histograms.html
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;