Click the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stock chart to which you want to add lines or bars. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

Function returns historical price data about the financial instrument corresponding to this value. Enter a ticker symbol in double quotes (e.g., "MSFT") or a reference to a cell containing the Stocks data type. This will pull data from the default exchange for the instrument.

Learn to create a chart and add a trendline. You can start your document from a recommended chart or choose one from our collection of pre-built chart templates.

Many chart types are available to help you display data in ways that are meaningful to your audience. Here are some examples of the most common chart types and how they can be used.

To get a stock quote, you need to add a linked record for a company or fund. Then you can use another column to extract the price. This article explains how.

Before you choose either a scatter or line chart type in Office, learn more about the differences and find out when you might choose one over the other.

After creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits.

By using regression analysis, which estimates the relationship between variables, you can extend a trendline in a chart beyond the actual data to predict future values.

Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.

Use the charting features of Word and Excel to present your data in a pie, line, or bar chart or graphical format.