Arrange Chart Diploma For Free

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. Click the Move Up or Move Down arrows to move the data series to the position that you want.

Reorder chart series Right click at the chart, and click Select Data in the context menu. ... In the Select Data dialog, select one series in the Legend Entries (Series) list box, and click the Move up or Move down arrows to move the series to meet you need, then reorder them one by one. Click OK to close dialog.

Right click on the Horizontal axis and select the Format Axis? item from the menu. You'll see the Format Axis pane. Just tick the checkbox next to Categories in reverse order to see you chart rotate to 180 degrees.

Click anywhere in the chart. Under Chart Tools, on the Design tab, in the Location group, click Move Chart.

To move a chart in Excel within a worksheet, click and drag inside the ?Chart Area? of the chart. The mouse pointer appears as a four-pointed arrow while you click and drag to move the chart. When the chart is in the desired location, release the mouse button to drop the chart into its new worksheet location.

Create a chart Click anywhere in the data for which you want to create a chart. ... Select Insert > Charts > and the chart type you want. On the menu that opens, select the option you want. ... To edit the chart (titles, legends, data labels), select the Chart tab and then select Format.

You can sort chart categories by a category value (in the Axis box) or by a numeric value (in the Values box). Hover over the top edge of a chart until you see sort by in the upper-left corner, then the name of a field, and then either asc or desc. Click the field name to sort on a different value.