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" wrote in message
...
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