You could modify the data in the cells.

If you have Excel 2003 or earlier you can select a point (a bar), which
takes a single click to select the series then another single click to
select the point, then move the mouse to the top of the bar and the
cursor changes to a two headed vertical arrow. Click and drag the end of
the bar, and the data in the worksheet will change accordingly.

Excel 2007 has lost this capability.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



M E Mathis wrote:
I have two data series and I can create two different histograms showing the
shape of the data in each series. I want to reshape one histogram (modify
the data) so that it looks like the other histogram. How do I do this?