Change color of Autoshape in chart

[John Michl]

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

 

[Jon Peltier]

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

 

[John Michl]

Thanks, Jon. I was afraid of that. I think my workaround will be to
draw four versions of the arrow each with a different color and then
use those as legend on the chart. Each will have a unique name. Then
I'll recopy the appropriate version onto each data point as I activate
the chart.

- John

 

[Jon Peltier]

Why not make four series, and adjust the visible points based on your
condition:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon