Prev: Using a variable for a chart limit
Next: conditional formatinf of graph series
From: jackrobyn1 on 27 Jun 2008 13:10
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!
From: Wigi on 27 Jun 2008 17:56
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!
From: Del Cotter on 27 Jun 2008 19:10
On Fri, 27 Jun 2008, in microsoft.public.excel.charting,
jackrobyn1 <jackrobyn1(a)discussions.microsoft.com> 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 del(a)branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.
From: Mais qui est Paul on 28 Jun 2008 07:32
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

--
--
@+
;o)))

 | 
Pages: 1
Prev: Using a variable for a chart limit
Next: conditional formatinf of graph series