Latest posts by techwriter (see all)
- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 2016
- How to View a List of All Open MS Word Documents through VBA Macro - August 31, 2016
Excel’s Chart Wizard and documentation use several charting terms:
data markers, data-marker descriptions, legend, chart text, plot area, and chart area.
You’ll find it useful to understand just what these words and phrases mean, so the bulleted list that follows provides definitions.
Data markers are the graphical elements used to represent individual data point values
in a chart. In the case of a line chart, for example, Excel uses uses symbols, or points, on a line to show data point values. These symbols or points are the data markers.
Other types of charts in Excel use other data markers. A chart that uses columns or bars, for example, has column or bar data markers. A pie chart has pie-slice data markers, and so on.
Data marker descriptions
Excel typically describes and qualifies data markers using the data-marker descriptions such as axis scales and data labels.
Different types of charts use different data-marker descriptions. Bar, column, and line charts use axis scales. Pie and doughnut charts use data labels.
A legend names and identifies the data series you’ve plotted. In the case of a pie chart, for example, the legend typically names the data series and then also shows which colors are used for which pie slices.
In charts that show multiple data series, the legend lists all of the data series and visually shows chart viewers how to identify data series.
Chart text predictably describes a chart or some part of a chart. A chart might include a title that shares the chart message such as “Industry Continues to Grow” or a subtitle that clarifies some bit of information about the chart such as “(five-year forecast of domestic revenues)”.
The plot area of a chart is the area that includes the data markers and data-marker descriptions.
In many charts, the plot area is a rectangle that shows the lines and scales representing the plot area.
In same cases–such as the case of a pie chart or doughnut chart—-the circle that shows the slices of pie and the data labels that identify the slices of pie comprise the plot area.
The chart area includes plot area, any chart text, and a legend. In other words, the chart area represents the whole enchilada.
About the author: Seattle CPA Stephen L. Nelson wrote the bestselling book, MBA’s Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits the S Corporations Explained and LLCs Explained websites.
Want to read more about MS Excel tips and tutorials? Visit Hot Excel.