Search results
Results From The WOW.Com Content Network
You can add other lines to any data series in an area, bar, column, line, stock, xy (scatter), or bubble chart that is 2-D and not stacked. Add other lines. This step applies to Word for Mac only: On the View menu, click Print Layout.
Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis shows the values for the associated data series.
To make parts of a pie chart stand out without changing the underlying data, you can pull out an individual slice, pull the whole pie apart, or enlarge or stack whole sections by using a pie or bar of pie chart. To emphasize an individual slice of a pie chart, you can move it back from the rest of the pie chart by doing the following:
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.
To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales volumes. Note: To create a combination chart, you must use a 2-D chart, such as a 2-D Line, 2-D Column, Scatter, or Bubble chart.
For charts that display chart elements in 3-D without using a third, depth axis (such as a pie in 3-D, bar in 3-D, or stacked area in 3-D chart), you can change the 3-D format of the 3-D chart elements.
To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.
Area and 3-D area Shown in 2-D or in 3-D format, area charts show the trend of values over time or other category data. 3-D area charts use three axes (horizontal, vertical, and depth) that you can change.
You can use error bars in 2-D area, bar, column, line, xy (scatter), and bubble charts. In scatter and bubble charts, you can show error bars for x and y values.
In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels.