Change the scale of the vertical (value) axis in a chart
Change the scale of the vertical (value) axis in a chart. Applies To. 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.
Change the display of chart axes - Microsoft Support
Change the alignment and orientation of labels. You can change the alignment of axis labels on both horizontal (category) and vertical (value) axes. When you have multiple-level category labels in your chart, you can change the alignment of all levels of labels.
Create a waterfall chart - Microsoft Support
Create a sunburst chart in Office. Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
Change the scale of the horizontal (category) axis in a chart
To change the series overlap or gap width, right-click a data series, and then click Format Data Series. Under Series Options, specify the settings that you want. By default, the minimum and maximum scale values of each axis in a chart are calculated automatically.
Explode or expand a pie chart - Microsoft Support
To more precisely control the expansion, follow these steps: Right-click the pie chart, then click Format Data Series. Drag the Pie Explosion slider to increase the separation, or enter a number in the percentage box. Tip: You can also give your pie …
Edit titles or data labels in a chart - Microsoft Support
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.
Change the font size - Microsoft Support
You can also click the Increase Font Size or Decrease Font Size (Grow Font and Shrink Font in some earlier versions of Office programs) icons until the size you want is displayed in the Font Size box.
Add and format a chart legend - Microsoft Support
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.
Add a trend or moving average line to a chart - Microsoft Support
Formatting a trendline is a statistical way to measure data: Set a value in the Forward and Backward fields to project your data into the future. Add a moving average line. You can format your trendline to a moving average line. Click anywhere in the chart.
Change axis labels in a chart - Microsoft Support
Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.
Curve text around a circle or other shape - Microsoft Support
You can use WordArt with a Transform text effect to curve or bend text around a shape. If you want the text to circle the shape, you can also do this, but it’s a little bit more work. You can also insert WordArt multiple times to wrap text around shapes with straight edges.