| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
