Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to find a method to place a chart at a specific cell location
within a worksheet. I am adding a chart using data within the spreadsheet and need to place the chart next to the data. I can't seem to find a method. The code I am using to add the sheet is as follows and I would like to place the top left hand corner in cell J2. Thanks BLandmine sName = ActiveSheet.Name Set sh = ActiveSheet Charts.Add ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=sh.Range("B3:C12"), _ PlotBy:=xlColumns ActiveChart.Location Whe=xlLocationAsObject, Name:=sName ActiveChart.HasLegend = False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003- Tabbing to a specific location in a cell | Excel Discussion (Misc queries) | |||
cell location containing specific text | Excel Worksheet Functions | |||
how do I draw a line in a chart at a specific location | Charts and Charting in Excel | |||
hyperlink an excel cell to a specific location wthin application f | Excel Discussion (Misc queries) | |||
ListBox Result to a Specific Cell Location | Excel Programming |