Search results
Results From The WOW.Com Content Network
Under Chart Tools, on the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of.
When the values in a chart vary widely from data series to data series, you can plot one or more data series on a secondary axis. A secondary axis can also be used as part of a combination chart when you have mixed types of data (for example, price and volume) in the same chart.
For most chart types, you can display or hide chart axes. To make chart data easier to understand, you can also change the way they look.
By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
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.
For most charts, such as column and bar charts, you can plot the data that you arrange in rows or columns on a worksheet into a chart. However, some chart types (such as pie and bubble charts) require a specific data arrangement. On the worksheet, arrange the data that you want to plot in a chart.
Change format of chart elements by using the Format task pane or the ribbon. You can format the chart area, plot area, data series axes, titles, data labels, and legend.
For example, if all the data points in your data table are between 60 and 90, you might want the value (y) axis to have a range of 50 to 100 instead of 0 to 100. When a value axis covers a very large range, you can also change the axis to a logarithmic scale (also known as log scale).
Steps for adding and changing the look of a chart legend in Office 2016 for Windows, including customizing the border, the background of the chart legend, and changing and resizing the font used in a chart legend.
To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.