I replaced the bar shape in a bar chart with an arrow drawn from the
Autoshape menu. First I drew the arrow on a spreadsheet then changed
the color and shading. Then I highlight a series in the chart and
pasted the arrow. This all works fine.

Is there a way to change the color of that shape once it is in the
chart? I have some VBA code that changes other characterstics such as
location and formating of each data point's data label but if I try to
change the color, the arrow goes away and a full bar replaces it.

I know how to cycle through the data points in the series, I just
don't know how to change the color of the autoshape versus the entire
bar or column.

Thanks.

John