Joe can probably find a useful example on this web page:

http://www.geocities.com/jonpeltier/...arts/axes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Michael R Middleton wrote:
Joe Gruher -


I want to manually make a histogram. I create a bar chart and set the gap

to zero. The problem I have is with the x-axis data labels. They are
aligned with the bars. For a histogram they should be aligned with the tick
marks (the divisions between bars) since they indicate boundaries. How do I
move the labels??????

As far as I know, it's not possible.

The only workaround I know is to use a combination chart (Column and XY
Scatter) where the axis of the XY Scatter chart is used for labeling the
axis. It's time consuming, and I don't have step-by-step instructions.

- Mike Middleton, www.usfca.edu/~middleton