On Fri, 27 Jun 2008, in microsoft.public.excel.charting,
jackrobyn1 said:
I am using the camera tool to create a background for a chart so that when
the results reach a certain level the surrounding background changes to
green, or red if poor results etc The problem i have may seem cosmetic but
the picture (camera object) has sharpe corners where rounded would be more
desirable for the charts appearence. how can i achieve this? any help would
be apreciated.

I have seen similar charts on Charley Kyds website but there are no
instructions on how its done!

Here are the instructions:

http://www.exceluser.com/solutions/traffic.htm

You need to create a text box using an Autoshape with rounded corners,
or create a rectangular text box and change Autoshape to one with
rounded corners. Then put the object in a cell that the camera tool will
refer to.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.