Hi Del,

Re your postscript. When you copy it back from the column it becomes a
picture, with transparency, rather than a autoshape. So setting the fill
colour will indeed colour the empty/non picture part.

Cheers
Andy

Del Cotter wrote:
On Fri, 2 Feb 2007, in microsoft.public.excel.charting,
Mitzi said:

Can I change a bar graph to have an arrow at the top or bottom?


Yes you can. Use the Autoshapes menu in the Drawing toolbar, and select
an arrow form you like the look of. When you've created it, Cut (or
Copy) it, select a bar, and Paste the arrow. The bar will now be an
arrow shape instead of a rectangle. Repeat with the other bar series
until done.

Change the border and fill colours to suit before you paste the arrow,
because you won't be able to do it afterward. If you try, you'll only
surround the arrow with a rectangular coloured border, and hide the
arrow with a rectangular fill colour.

Postscript: hey, I didn't expect that to happen! I just experimented
with copying and pasting the arrow back out of the bar and on to the
plot area again, which worked, but when I tried to change the arrow's
fill colour it didn't work. But neither did the fill colour cover the
arrow, as it did when it was part of the bar. Instead it filled *under*
the arrow, making a neat rectangular background! That's an unexpected
result. The multicoloured shape now pastes back into the bar. Repeating
the process produces a narrow border of a third fill colour around the
rectangle, but that seems to be the limit of recursion: further cutting
and pasting produces no more nested levels of fill colour.