Thread: graph
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eli5m eli5m is offline
external usenet poster
 
Posts: 1
Default graph


1. how do i delete graphs from worksheet


2. i create 2 graphs in one sheet - i need to move it to right side
used this code :

ActiveChart.ChartArea.Select
ActiveSheet.Shapes(ChartName).IncrementLeft 140.5
ActiveSheet.Shapes(ChartName).IncrementTop 100.25

but the problem is when i copy the excel file to a different compute
the location
is changing ... so how do i make it fit to all??

--
eli5
-----------------------------------------------------------------------
eli5m's Profile: http://www.excelforum.com/member.php...fo&userid=1475
View this thread: http://www.excelforum.com/showthread.php?threadid=26380