Chapter 17. Formatting Charts

You use Excel’s chart format objects to change the fonts, backgrounds, images, and 3-D effects used on a chart. This chapter covers those tasks to take you far beyond the basic chart types and default formatting .

This chapter includes task-oriented reference information for the following objects and their related collections: AxisTitle, ChartArea, ChartColorFormat, ChartFillFormat, ChartTitle, Corners, DataLabel, DisplayUnitLabel, DownBars, DropLines, ErrorBars, Floor, Gridlines, HiLoLines, LeaderLines, Legend, LegendEntry, LegendKey, PlotArea, TickLabels, Trendline, Trendlines, UpBars, and Walls.

Tip

Code used in this chapter and additional samples are available in ch17.xls.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.