Once you apply a custom shape to the marker or fill of a chart series, you
can't reformat it. You have to reformat the original shape, and reapply it
to the point or series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John Michl" wrote in message
oups.com...
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