Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line up graphs
Try something like
ActiveSheet.ChartObjects(1).Top = Range("E5").Top ActiveSheet.ChartObjects(1).Left = Range("E5").Left -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "S" wrote in message ... Hi I am just wondering is it possible for me to line up graphs in macro? For instance, I want to line up the top left corner of a graph with cell "E5". Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line up graphs
How does it work for i=0?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "S" wrote in message ... Nevermind. The code I put below actually does work. "S" wrote: Thanks! What if I got a lists of graphs to align? Do those commands work in a For loop? What does the "index" do in the ChartObjects(index)? I tried the following but it doesn't work: For i = 0 To 1 ActiveSheet.ChartObjects(i).Top = Range("F" & i).Top ActiveSheet.ChartObjects(i).Left = Range("F" & i).Left Next Thanks! "Chip Pearson" wrote: Try something like ActiveSheet.ChartObjects(1).Top = Range("E5").Top ActiveSheet.ChartObjects(1).Left = Range("E5").Left -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "S" wrote in message ... Hi I am just wondering is it possible for me to line up graphs in macro? For instance, I want to line up the top left corner of a graph with cell "E5". Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
line graphs | Excel Discussion (Misc queries) | |||
Line graphs | Charts and Charting in Excel | |||
Line graphs | Charts and Charting in Excel | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |