Traffic light problem

[jackrobyn1]

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!

 

[Wigi]

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

 

[Del Cotter]

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.

 

[Mais qui est Paul]

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").RoundedCorners = 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