To get the best results from Excel’s Chart Wizard, you’ll want to learn the terminology that Excel uses to refer to the pieces and parts of the charts you build, says bestselling computer book author Stephen L. Nelson.
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
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.
Legend
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
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)".
Plot area
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.
Chart area
The chart area includes plot area, any chart text, and a legend. In other words, the chart area represents the whole enchilada.
Mastering Accrued Interest Calculations with Microsoft Excel
Microsoft Excel is not just a spreadsheet program; it's a powerful tool for financial calculations, including the computation of accrued interest for various securities. Excel's built-in functions, ACCRINT and ACCRINTM, are specifically designed to simplify the process of calculating accrued interest for securities that pay periodic interest and those that pay at maturity, respectively. This article delves into the nuances of these functions, providing a detailed guide on how to use them effectively, along with common pitfalls to avoid.
Using the Bond Duration Add-in Functions
Making bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations.
Using Excel's Xirr and Xnpv Add-in Functions
Making internal rate of return or net present value calculations with Microsoft Excel? Make sure you aren't unnecessarily limiting your options. In addition to the well-know IRR and NPV financial functions, Microsoft Excel also supplies two powerful add-in functions, XIRR and XNPV, that can expand your analytical possibilities.
