Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have different problems with the object model of charts in Excel. Are there any good information about this object model? I only find small examples. I want to create an xy-chart with several lines composed of at least three points. Is there a way to do this point by point? My first trial makes this by creating a range, which is made with union for each point. I also want to add a label to some of this points. Is it possible to do this while creating the serie? Would be easier for me. I don't want to be bearish, but I have some other questions as well: What happens to the chart after this line: chChart.Location Whe=xlLocationAsObject, Name:="sheet 1" Any attemp to access "SeriesCollection" raises an error. Is there a possibility to create a new chart direct in a sheet - not as an extra sheet? And the very last question: I want to move the chart on the sheet. For this, I trie to use the chartobject. But this line doesn't work: Dim coChartObject As ChartObject Set coChartObject = chChart.Parent Thanks in advance, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting chartobject without index no. | Charts and Charting in Excel | |||
Passing chartobject as a parameter to sub | Excel Programming | |||
how to set a variable to a Chart? not ChartObject | Excel Programming | |||
ChartObject Name Restricion or Excel Bug | Excel Programming | |||
ChartObject index | Excel Programming |