Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| docs:programming:office_vba:charts [2007/07/12 12:04] – created billh | docs:programming:office_vba:charts [2008/08/03 00:25] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Charts ====== | ====== Charts ====== | ||
| + | |||
| + | ===== programmatically update a chart title ===== | ||
| + | |||
| <code vb> | <code vb> | ||
| Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) | Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) | ||
| Line 6: | Line 9: | ||
| Dim currAvg As Integer | Dim currAvg As Integer | ||
| currAvg = Application.WorksheetFunction.Floor(Worksheets(" | currAvg = Application.WorksheetFunction.Floor(Worksheets(" | ||
| + | |||
| With Chart1 | With Chart1 | ||
| .HasTitle = True | .HasTitle = True | ||