Trying to draw a histogram with various non equal age bands vs income,
neeed to do this as a histogram
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.
"Tools" --> "Data Analysis" --> "Histogram" --> "OK" --> select the range
containing the income data for "Input Range" --> select the range containing
the non-equal age-bands for "Bin Range" --> select a cell in an empty area
for "Output Range" --> "OK"
Please note that the "Data Analysis" 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
"HB 44" wrote:
> Trying to draw a histogram with various non equal age bands vs income,
> neeed to do this as a histogram
HB 44 -
> Trying to draw a histogram with various non equal age bands vs income,
> neeed to do this as a histogram <
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:
http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zip
Jon Peltier's Excel Chart Pages has general information about histograms:
http://peltiertech.com/Excel/Charts/Histograms.html
- Mike
www.mikemiddleton.com
Here are more links to variable width column charts:
http://peltiertech.com/Excel/ChartsH...thColumns.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Mike Middleton" <[email protected]> wrote in message
news:[email protected]...
> HB 44 -
>
>> Trying to draw a histogram with various non equal age bands vs income,
>> neeed to do this as a histogram <
>
> 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:
>
> http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt5.zip
>
>
> Jon Peltier's Excel Chart Pages has general information about histograms:
>
> http://peltiertech.com/Excel/Charts/Histograms.html
>
> - Mike
> www.mikemiddleton.com
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks