Can Excel draw a histogram with variable column widths

[Guest]

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

 

[Guest]

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

 

[Mike Middleton]

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.asp?file=FunChrt5.zip


Jon Peltier's Excel Chart Pages has general information about histograms:

http://peltiertech.com/Excel/Charts/Histograms.html

- Mike
www.mikemiddleton.com

 

[Jon Peltier]

Here are more links to variable width column charts:

http://peltiertech.com/Excel/ChartsHowTo/VariableWidthColumns.html

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