Microsoft Office Tutorials and References
In Depth Information
The Chapter Examples directory
chart events - embedded chart.xls — Demonstrates various events for an
embedded chart
chart protection.xls — Contains macros to protect and unprotect various
aspects of a chart
conditional formatting.xls — Contains a macro to change column colors
based on values
create a chart.xls — Contains a macro to create a chart using the selected
data range
create five charts.xls — Contains a macro to create a chart for the data in
five worksheets
data label macro.xls — Contains a macro that uses an Input Box to prompt
for a range that contains data labels
freeze text size.xls — Contains a macro to free the font size of chart text
items
get series ranges.xls — Contains functions that determine the data type
and values of data used in a chart series
hide charts - event macro.xls — Demonstrates the use of a
Worksheet_Change event procedure to hide and unhide charts
looping through charts.xls — Contains macros that use loops to perform
operations on all charts
mousedown event - chart sheet.xls — Demonstrates the MouseDown event
for a chart sheet
mousedown event - embedded chart.xls — Demonstrates the MouseDown
event for an embedded chart
mouseover event - chart sheet.xls — Demonstrates the MouseOver event
for a chart sheet
mouseover event - embedded chart.xls — Demonstrates the MouseOver
event for an embedded chart
print all charts.xls — Contains a macro to print all embedded charts on a
separate page
random gradient.xls — Contains a macro to apply a random two-color
gradient to a chart series
save as gif.xls — Contains a macro to save a chart as a GIF file
scrolling stock chart.xls — Contains a macro to scroll a chart horizontally
size and align charts.xls — Contains a macro to size and align all
embedded charts
Search JabSto ::




Custom Search