Traffic light problem

  • Thread starter Thread starter jackrobyn1
  • Start date Start date
J

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!
 
This is not an Excel problem, but more something for a graphical program like
Photoshop. Search the internet and you will find answers.
 
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!
Click to expand...

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.
 
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!
Click to expand...

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
 
Back
Top