Windowblinds 7 Change Isid

Graphics ( Chart) - Excel - Excel Charts 1

Object Model - Graph (Chart) ---------------------------------


Application Workbook ChartObjets


Chart Worksheet

Conocinedo this structure to the object model - graphic may access a given graph to modify according to taste.

On a graph with its corresponding index, ie the index number that corresponds within the collection.

From here on out will be better as refererise the graphic chart (translated) is more practical because that is used in the code.


a simple example would the active chart sheet number 3 of course there is always ..(..)

ActiveSheet.ChartObjects (3).
Activate

can elimininar Similarly the index chart 2. Remove a given chart

ActiveSheet.ChartObjects (2).

Delete Rename
a given chart
ActiveChart.Parent.Name = "ChartDeudas"

Change the title of a chart
ActiveChart.ChartTitle.Text = " Debt "Turning a graph

by name
Activesheet.Chartobjects (ChartDeudas").
activate

Retrieve the name of the active chart
------------------- Msgbox

---------------- ActiveChart.Name

'I will return a string like this first reference to the sheet and then the name of the chart. Sheet1 Chart 1



ActiveChart.parent.Name
Msgbox "I will return exactly what I imagine you were looking for ... just the name of Chart 1 chart



the next entry in the continuation of charts ..