Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 25
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 396
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
traffic light in excel Lumar Excel Discussion (Misc queries) 4 January 21st 10 04:02 AM
hi-light every other set of columns MarkT Excel Discussion (Misc queries) 3 March 20th 08 04:54 PM
traffic in erlang Ajinkya Dhume Excel Worksheet Functions 2 November 10th 07 09:42 PM
Traffic Light Filter On Dates JPG Excel Discussion (Misc queries) 3 April 17th 06 12:32 AM
Traffic needed. Can anyone help? Conrad Carlberg Excel Worksheet Functions 0 September 25th 05 06:06 PM


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"