Changing bar to an arrow

[waxwing]

Is there a way for me to change the bar in a bar chart to look like an
arrow? I've hear of using custom graphics instead of the bar but I
don't know how to do this. Thanks.

- John

 

[Andy Pope]

Hi,

You can use an autoshape arrow as a custom fill picture for your bars.
Create and format an arrow as required. Select and copy (CTRL+C) the
arrow. In the chart select the required series bars and paste (CTRL+V)

You can then right click the series and on the Patterns tab press the
Fill Effects button. This will allow you to control the stretch and
stack options of the arrow in relation to the bars value.

For further assistance see Jon Peltier's explanation. It's based on
Excel but will work with MSGraph.
http://peltiertech.com/Excel/ChartsHowTo/CustomStacks.html

Cheers
Andy

 

[waxwing]

Thanks. This is exactly what I'm looking for. - John