Microsoft Office Tutorials and References
In Depth Information
Adding a Chart to a Chart Sheet
To change your default type of chart, right-click any chart in your workbook and
select Change Chart Type. In the Change Chart Type dialog box, select a chart
type, click the Set as Default Chart button, and click the OK button.
Simply executing the code line Charts.Add in the Immediate Window creates a new chart sheet.
If the active cell were within a table of data, your default type chart would occupy the new chart
sheet, representing the table, or more precisely, the data within the CurrentRegion property of
the selected cell. If you did not have any data selected at the time, a new chart sheet would still
be created, with a blank Chart object looking like an empty canvas waiting to be supplied with
source data.
did you knoW…
If the active cell is within a table of data, or you have a range of data selected,
and you press the F11 key, a new chart sheet will be added to hold a chart that
represents the selected data. Some people find this to be an annoyance because
they have no interest in charts and don’t even know they touched the F11 key.
If you want to negate the effect of pressing the F11 key, you can place the
following OnKey procedures into the ThisWorkbook module. Some Excel users who
frequently use the F2 key to get into Edit mode nullify the F1 (Help) key in this
fashion as well.
Private Sub Workbook_Open()
Application.OnKey “{F11}”, “”
End Sub
Private Sub Workbook_Activate()
Application.OnKey “{F11}”, “”
End Sub
Private Sub Workbook_Deactivate()
Application.OnKey “{F11}”
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey “{F11}”
End Sub
Search JabSto ::

Custom Search