>
>You are probably aware that when you try to draw a histogram in Excel
>(whether by using the Analysis Tool, or using a column chart with no gaps
>between the bars) the x-axis labels (usually the class limits) are placed at
>the MIDPOINTS of the bars.  I have always found this very irritating.
>


Hello,

I am new to the list, writing from Paris. This point (histogram labelling)
is a real trouble, and I have worked some solutions about this (I never
thougt about Formatting, I think it should be considered as a patch : if
you are redimensionning the graphic, the labels will move relatively to the
bounds).

I have two solutions about the problem :

1 - use a scatterplot to emulate a real histogram. This is the only way if
you have class intervals of different widths, as this is the only graph
type where the X-axis is a real mathematical axis.

2 - if you use class intervals of the same width, you may have an other
solution using a dummy stacked graph (I am not sure about the english words
for the graphic).
Use all the 4 axis (X, Y main graph AND X, Y secondary graph), and with the
right combination, you can manage (you have to try many times).
It's a little bit contrieved, but it works with real graphical elements (so
you can move them, resize, ...)

If you are interested, I can explain how to do that. If you want to use it
without question (or like to explore by yourself),
I send an attached Excel 5 file for method 2 Even class widths
(I don't know already the proper way to send attached files, so excuse me
if I am wrong).


The graph use 3 local names :
X	the range with the bounds (p+1, if you have p classes)
X0	range of the same dimension filled with 0
	for the dummy main graph
Y	the range with the class counts

You may insert or delete rows, or modify as you like the names, as long that
X and Y are unidimensionnals and
Y have exactly one element more than X

Any comment welcome.

Francois Sermier
Paris