Microsoft Office Tutorials and References
In Depth Information
The Chapter Examples directory
first point and number of points.xls — Demonstrates how to use cells to
determine the beginning and end point and the number of data points for
a chart series
plot data in active row - F9.xls — Demonstrates a technique to plot the
data contained in the row that contains the cell pointer
plot data in active row - macro.xls — Demonstrates a technique to plot
the data contained in the row that contains the cell pointer (macro-driven
version)
plot every nth value.xls — Demonstrates how to plot every nth data point
plot last n data points.xls — Demonstrates how to plot the last n data
points
select series with checkboxes.xls — Demonstrates how to use checkboxes
to select series to display
CHAPTER 8 EXAMPLES
3d scatter plot - rotate.xls — Contains a simulation of a 3-D scatter chart,
with animation
area under a curve.xls — Demonstrates how to calculate the area under
a curve
bands in XY chart.xls — Demonstrates how to display horizontal or
vertical bands in an XY chart
bar and XY combination.xls — Demonstrates how to display a line on
a bar chart
box plot.xls — Demonstrates how to create box plots
broken axis.xls — Demonstrates two way to simulate a “broken” axis
conditional formatting.xls — Demonstrates how to vary the colors in
a column chart, based on values
data labels as markers.xls — Demonstrates how to use data labels as
markers in an XY chart
dummy axis.xls — Demonstrates how to create a dummy axis
frequency distributions.xls — Contains examples of frequency
distributions and histograms
function plot 2D.xls — A general purpose application to plot functions
with one variable
Search JabSto ::




Custom Search