Traffic light problem
 

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!

Traffic light problem
 

This is not an Excel problem, but more something for a graphical program like
Photoshop. Search the internet and you will find answers.



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"jackrobyn1" wrote:

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!

Traffic light problem
 

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.

Traffic light problem
 

Bonsour® jackrobyn1 avec ferveur ;o))) vous nous disiez :

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!

Perhaps :
for each graph
Sheets("SH1").DrawingObjects("GraphX").RoundedCorn ers = True
Sheets("SH1").DrawingObjects("GraphX").Shadow = True

and
for each camera object
ActiveSheet.Shapes("Picture Z").Fill.Visible = msoFalse
ActiveSheet.Shapes("Picture Z").Line.Visible = msoFalse

HTH

--
--
@+
;o)))