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.
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). When you release the mouse button, the title remains at the new location.Chart Elements in Excel VBA ( Part 1) - Chart Title, Chart Area, Plot Area, Chart Axes, Chart Series, Data Labels, Chart Legend As you move the mouse, the title is also moved. Use the mouse to point to the border around the title. When you do, it becomes surrounded with a box and handles. To do this, use the mouse to select the title text. You can move titles very easily, however. Thus, an axis title will be centered on the axis. When you add titles to your chart, Excel places them in a position it feels is best for the title. To signify that you are finished entering title text, you must use the mouse pointer to select some other part of your chart or worksheet.
Notice that if you press Enter, the cursor only moves to the next line you are still adding to the title. Click the mouse pointer once to edit the text. When you move the mouse pointer inside the box, it changes to an insertion point. The title is selected and surrounded with a box and handles. All you need to do is click on the title. There is an easier, more direct way to change title text, however. To change the text contained within a title, you can always follow these same steps again. Within the chart itself, click within a title box and modify the title text as desired.The selected axis titles appear in your chart. Choose the options appropriate for your needs.
You'll see options that indicate the axis titles you can display.