When finished, close the Format Data Series pane. Browse through the remaining options on the Series Options drop-down menu, including chart and plot areas, and axis settings. Next, select Chart Title from the Series Options dropdown menu, enter a new title, then adjust the alignment based on your preferences.Īgain, notice how the chart has changed. Then select Number and choose the number format you prefer from the list.Ħ. Under Axis Options > Bins, select By Category. For Tick Marks, choose whether you’d like to see them inside or outside the chart, or Cross (both inside and outside), or other options. Select Horizontal Category Axis from the list.ĥ. Click the down arrow beside Series Options and browse through the drop-down menu to ascertain how each of these options perform. Move the slider to change the gap width-that is, the space between each column on the chart.Ĥ. In the Format Data Series pane, click Series Options (the chart icon). Right-click any of the rectangles on the chart and select Format Data Series. Browse through the options and choose your favorite.ģ. The style changes are subtle, such as location of the legend or font attributes. Then click the paintbrush to change the chart’s style, design, and colors. Click the + sign to edit the chart elements: Axes, Axes Titles, Chart Title, Data Labels, Gridlines, and Legend.
