VBA Code, My excel macro creates the charts on top of each other
 

HI, I have a program that creates 5 charts with series data but my
problem is that all 5 charts and aligned on top of each other. I
couldn't figure out anyway to code to put each chart to be on its own
spot, other words able to see all charts when it creates the charts..

Help.. thanks


--
osman
------------------------------------------------------------------------
osman's Profile: http://www.excelforum.com/member.php...o&userid=34226
View this thread: http://www.excelforum.com/showthread...hreadid=564336

VBA Code, My excel macro creates the charts on top of each other
 

If you will share some of your code, you stand a better chance of getting help.
--
Best wishes,

Jim


"osman" wrote:


HI, I have a program that creates 5 charts with series data but my
problem is that all 5 charts and aligned on top of each other. I
couldn't figure out anyway to code to put each chart to be on its own
spot, other words able to see all charts when it creates the charts..

Help.. thanks


--
osman
------------------------------------------------------------------------
osman's Profile: http://www.excelforum.com/member.php...o&userid=34226
View this thread: http://www.excelforum.com/showthread...hreadid=564336

VBA Code, My excel macro creates the charts on top of each other
 

Use the Top and Left properties of the


"osman"
wrote in message
...

HI, I have a program that creates 5 charts with series data but
my
problem is that all 5 charts and aligned on top of each other.
I
couldn't figure out anyway to code to put each chart to be on
its own
spot, other words able to see all charts when it creates the
charts..

Help.. thanks


--
osman
------------------------------------------------------------------------
osman's Profile:
http://www.excelforum.com/member.php...o&userid=34226
View this thread:
http://www.excelforum.com/showthread...hreadid=564336

VBA Code, My excel macro creates the charts on top of each other
 

Use the Top and Left properties of the ChartObject to set the
charts where you want. Using a cell reference is convenient.

Dim CHT As ChartObject
' create your chart
CHT.Top = Range("C3").Top
CHT.Left = Range("C3").Left


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"osman"
wrote in message
...

HI, I have a program that creates 5 charts with series data but
my
problem is that all 5 charts and aligned on top of each other.
I
couldn't figure out anyway to code to put each chart to be on
its own
spot, other words able to see all charts when it creates the
charts..

Help.. thanks


--
osman
------------------------------------------------------------------------
osman's Profile:
http://www.excelforum.com/member.php...o&userid=34226
View this thread:
http://www.excelforum.com/showthread...hreadid=564336