A 2-D chart's plot area contains: the data markers, gridlines, data labels, trendlines & optional chart items placed in the chart area. A 3-D chart's chart area contains the chart title & the legend, without including the plot area) Plot Area (area where chart data is plotted - the Plot Area is surrounded by the Chart Area. Individual chart elements can be formatted & manipulated in vba code, such as: Chart Area (A 2-D chart's chart area contains: the axes, the chart title, the axis titles & the legend.
ADJUSTING GRIDLINE VALUES FOR SCATTER CHART IN EXCEL SERIES
This chapter discusses some important chart elements contained on a chart, which include: chart area (ChartArea object) chart title (ChartTitle object) plot area (PlotArea object) chart series (Series object - single series in a chart, SeriesCollection object - a collection of all the Series objects in a chart, Error Bars, Leader Lines, Trendlines, Point object - single points, Points object - collection of all Point objects in a series) chart axis (Axis Object - a single axis, Axes Object - collection of all the Axis objects in a chart, Gridlines object - major & minor gridlines, TickLabels Object - tick marks on an axis) chart Legend (Legend object, LegendEntry object - a single legend entry, LegendEntries object - a collection of legend entries, LegendKey object) data labels (DataLabel object - a single data label, DataLabels object - all data labels in a chart or series). Chart Elements in Excel VBA ( Part 1) - Chart Title, Chart Area, Plot Area, Chart Axes, Chart Series, Data Labels, Chart Legend