| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autopublishing creates a bitmap of charts and text boxes | Excel Discussion (Misc queries) | |||
| Macro creates additional datafiles when saving copies of workbook | Excel Programming | |||
| selecting variable rows in a macro that creates a pivot table | Excel Programming | |||
| How to Rename a Blank Sheet that a macro Creates | Excel Programming | |||
| Macro that creates a directory but... | Excel Programming | |||
![osman[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
