Mammal And Reptile At 10 C Respiration

Graphics Chart (Chart) - Excel - Excel Charts 2

Change type of Chart


------------------------ Sub ChangeChartType ()

'Changing the type of Chart

ActiveChart.Type = xl3DPie
ActiveChart . ChartType = xl3DLine

'According to see the 2 forms are valid to change the chart type
' likewise can select the constant xl3DPie and press CTRL + J
'and thus access to the list of other types of charts
' or you can also try recording your own macros and thus check the rates available in a simple way

End Sub Sub



ConvertChartInsheet ()

'Likewise, you can convert the active Chart a new chart sheet
ActiveChart.Location Where: = xlLocationAsNewSheet, Name: = ActiveChart.Parent.Name



End Sub Delete the graphics in the active sheet

Sub DeleteAllcharts ()

ActiveSheet.ChartObjects.Delete




End Sub 'remove all the leaves of the book chart Sub

DeleteAllcharts1 ()

ActiveWorkbook.Charts.Delete




End Sub The entry sgte try on the elements of Chart Chart
area, Plot area, legend, axes, etc. ..