Search results
Results from the WOW.Com Content Network
Learn how to customize the minimum and maximum values, the tick marks, the display units, and the logarithmic scale of the vertical axis in a chart. Follow the steps to select the axis, format it, and see the tips and examples.
Learn how to reverse the order of categories, values, or data series in a chart by using the Format Selection or Select Data options. This can help you improve the visibility and readability of your chart axes and data markers.
Learn how to plot one or more data series on a secondary vertical axis in Excel when the numbers vary widely or you have mixed types of data. Follow the steps for Windows or Mac to change chart type, add or remove a secondary axis, and add an axis title.
Learn how to display or hide, format, and customize axes in Excel charts. Find out how to adjust tick marks, labels, alignment, orientation, and text of horizontal, vertical, and depth axes.
A 3-D column, 3-D cone, or 3-D pyramid chart has a depth (series) axis, also known as the z axis, that you can change. You can specify the interval between tick marks and axis labels, change their placement along the axis, and reverse the order in which the series are displayed.
Learn how to add series lines, which connect the data series in 2-D stacked bar and column charts, to emphasize the difference in measurement between each data series. Follow the steps to add or remove series lines, drop lines, high-low lines, or up-down bars in different chart types.
Learn how to add or remove horizontal, vertical, and depth gridlines in Excel charts. Gridlines extend from axes across the plot area and align with tick marks.
Learn how to edit, format, and customize the text and numbers of the horizontal (X) and vertical (Y) axis labels in Excel charts. Follow the steps to change the source data, the label range, the font, the spacing, and the number format of the labels.
Learn how to show error bars in 2-D area, bar, column, line, xy (scatter), and bubble charts to see margins of error and standard deviations. Choose from predefined or custom error bar options, and change the direction, end style, or value of the error bars.
Set varying colors of data markers (bars, columns, lines, pie or doughnut slices, dots, and other shapes) automatically in an Office chart.
Learn how to edit titles and data labels on a chart, such as the name of the chart or the details of a data point. You can also change the position of data labels, format the text, and reestablish links to worksheet cells.