Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create chart at a cell address?
Is there a way to create a new chart at a certain cell address?
Currently I'm using: ActiveSheet.ChartObjects.Add(450, 50, 400, 300).Select ActiveChart.ChartType = xlXYScatterLines To create a new chart. instead of pixel offsets, I'd like to create a chart at Range("E5") for example. Any ideas? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create chart at a cell address?
Dim cht As Chart
With ActiveSheet.Range("E5") Set cht = ActiveSheet.ChartObjects.Add(.Left, .Top, 400, 300).Chart End With cht.ChartType = xlXYScatterLines 'etc Regards, Peter T wrote in message oups.com... Is there a way to create a new chart at a certain cell address? Currently I'm using: ActiveSheet.ChartObjects.Add(450, 50, 400, 300).Select ActiveChart.ChartType = xlXYScatterLines To create a new chart. instead of pixel offsets, I'd like to create a chart at Range("E5") for example. Any ideas? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create chart at a cell address?
The .left and .top properties of a range is handy. Thanks.
Peter T wrote: Dim cht As Chart With ActiveSheet.Range("E5") Set cht = ActiveSheet.ChartObjects.Add(.Left, .Top, 400, 300).Chart End With cht.ChartType = xlXYScatterLines 'etc Regards, Peter T wrote in message oups.com... Is there a way to create a new chart at a certain cell address? Currently I'm using: ActiveSheet.ChartObjects.Add(450, 50, 400, 300).Select ActiveChart.ChartType = xlXYScatterLines To create a new chart. instead of pixel offsets, I'd like to create a chart at Range("E5") for example. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
how do I create a cell reference from ADDRESS function return? | Excel Worksheet Functions | |||
can chart title be linked to variable cell address? | Excel Discussion (Misc queries) | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
Create Right Click Option to Copy Cell Address | Excel Programming |