Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I've got code to add a chart to my worksheet (below).
Range("A1:A10").Select Charts.Add ActiveChart.ChartType = xl3DColumnClustered ActiveChart.SetSourceData Source:=Sheets("Results").Range("A1:A10"), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsObject, Name:="Test" Now if I want to move that chart, I can use the following code. ActiveSheet.Shapes("Chart 1").IncrementLeft -63# ActiveSheet.Shapes("Chart 1").IncrementTop -153# Is there a way I can specify exactly where I want the left side of the chart to start. For example, if I want the chart to start where column F starts, how could I do this? Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
decimal placement in an excel chart? | Charts and Charting in Excel | |||
Cell placement | Excel Worksheet Functions | |||
Picture Placement | Excel Discussion (Misc queries) | |||
Name Placement | Excel Discussion (Misc queries) | |||
Tab placement | Excel Discussion (Misc queries) |