Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
traffic light in excel | Excel Discussion (Misc queries) | |||
hi-light every other set of columns | Excel Discussion (Misc queries) | |||
traffic in erlang | Excel Worksheet Functions | |||
Traffic Light Filter On Dates | Excel Discussion (Misc queries) | |||
Traffic needed. Can anyone help? | Excel Worksheet Functions |