To sort multiple columns by weekday, month, or another custom list, use the previous 'Sort a list by two or three columns' procedure to sort each column separately. Sort dates or times Select a column of dates or times in a range of cells or in a table.
Arrows in the column headers appear. Click the arrow next to Date. Click on Select All to clear all the check boxes, click the + sign next to 2015, and click the check box next to January.
Excel only displays the sales in 2015, in January. Click the arrow next to Date. Click on Select All to select all the check boxes. Click Date Filters (this option is available because the Date column contains dates) and select Last Month from the list.
Excel only displays the sales of last month. Note: this date filter and many other date filters depend on today's date.
After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart in Word. On the View menu, click Print Layout. Click the chart. On the Chart Design tab, click Edit Data in Excel.
Excel opens and displays the data table for the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series. To add data to or edit data in a cell, click the cell, and then make the change. To see the results of your changes, switch to Word. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis.
In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. On the View menu, click Print Layout. Click the chart. On the Chart Design tab, click Switch Row/Column. Switch Row/Column is available only when the chart's Excel data table is open and only for certain chart types. If Switch Row/Column is not available:.
Click the chart. On the Chart Design tab, click Edit Data in Excel. To change the order of a data series, you need to work with a chart that has more than one data series.
On the View menu, click Print Layout. In the chart, select a data series. For example, in a column chart, click a column, and all the columns of that data series become selected. On the Chart Design tab, click Select Data. In the Select Data Source dialog box, next to Legend entries (Series), use the up and down arrows to move the series up or down in the list.
Depending on the chart type, some options may not be available. On the View menu, click Print Layout. In the chart, select a data series. For example, in a column chart, click a column, and all columns of that data series become selected.
On the Chart Design tab, click Select Data. In the Select Data Source dialog box, do one of the following.
To Do this Remove a series Under Legend entries (Series), select the data series that you want to remove, and then click Remove (-). Add a series Under Legend entries (Series), click Add (+), and then in the Excel sheet, select all the data that you want to include in the chart. When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis.
You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis. For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days. However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. On the View menu, click Print Layout. Click the chart, and then click the Chart Design tab.
Click Add Chart Element, click Axes, and then click More Axis Options. The Format Axis pane appears. For the axis that you want to change, make sure that the axis labels show. Under Axis Type, click Date axis. Under Units, in the Base drop-down list box, select Days, Months, or Years. Depending on the chart type, some options may not be available.
After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart in PowerPoint. Click the chart. On the Chart Design tab, click Edit Data in Excel. Excel opens and displays the data table for the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series.
To add data to or edit data in a cell, click the cell, and then make the change. To see your changes, switch to PowerPoint. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted.
Click the chart. On the Chart Design tab, select Switch Row/Column. Switch Row/Column is available only when the chart's Excel data table is open and only for certain chart types.
If Switch Row/Column is not available:. Click the chart.
On the Chart Design tab, click Edit Data in Excel. In the chart, select a data series. For example, in a column chart, click a column, and all columns of that data series become selected. Click the Chart Design tab, and then click Select Data. In the Select Data Source dialog box, do one of the following. To Do this Remove a series Under Legend entries (Series), select the data series that you want to remove, and then click Remove (-).
Add a series Under Legend entries (Series), click Add (+), and then in the Excel sheet, select all the data that you want to include in the chart. When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis. You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis.
For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days. However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. Click the chart, and then click the Chart Design tab. Click Add Chart Element, click Axes, and then click More Axis Options. The Format Axis pane appears. For the axis that you want to change, make sure that the axis labels show.
Under Axis Type, select Date axis. Under Units, in the Base drop-down list box, select Days, Months, or Years. Depending on the chart type, some options may not be available. After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart. Click the chart.
Excel highlights the data table that is used for the chart. The gray fill indicates a row or column used for the category axis. The red fill indicates a row or column that contains data series labels. The blue fill indicates data points plotted in the chart. Data series labels Values for the category axis Data points plotted in the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data.
In the following example, the table is expanded to include additional categories and data series. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. Click the chart.
On the Chart Design tab, click Switch Row/Column. In the chart, select a data series. For example, in a column chart, click a column, and all columns of that data series become selected. Click the Chart Design tab, and then click Select Data. In the Select Data Source dialog box, do one of the following. To Do this Remove a series Under Legend entries (Series), select the data series that you want to remove, and then click Remove (-).
Add a series Under Legend entries (Series), click Add (+), and then in the Excel sheet, select all the data that you want to include in the chart. When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis. You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis.
For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days. However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. Click the chart, and then click the Chart Design tab. Click Add Chart Element, click Axes, and then click More Axis Options.
The Format Axis pane appears. For the axis that you want to change, make sure that the axis labels show. Under Axis Type, select Date axis. Under Units, in the Base drop-down list box, select Days, Months, or Years.
Depending on the chart type, some options may not be available. After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart in Word. On the View menu, click Print Layout. Click the chart. On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.
Excel opens and displays the data table for the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data.
In the following example, the table is expanded to include additional categories and data series. To add data to or edit data in a cell, click the cell, and then make the change. To see the results of your changes, switch to Word. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument.
However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. On the View menu, click Print Layout. Click the chart. On the Charts tab, under Data, click Plot series by row or Plot series by column. If Switch Plot is not available Switch Plot is available only when the chart's Excel data table is open and only for certain chart types. Click the chart. On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.
To change the order of a data series, you need to work with a chart that has more than one data series. On the View menu, click Print Layout. In the chart, select a data series, and then click the Chart Layout tab. For example, in a column chart, click a column, and all the columns of that data series become selected. Under Current Selection, click Format Selection.
In the navigation pane, click Order, click a series name, and then click Move Up or Move Down. Depending on the chart type, some options may not be available. On the View menu, click Print Layout. In the chart, select a data series, and then click the Charts tab. For example, in a column chart, click a column, and all columns of that data series become selected.
Under Data, click the arrow next to Edit, and then click Select Data in Excel. In the Select Data Source dialog box, do one of the following. To Do this Remove a series Under Series, select the data series that you want to remove, and then click Remove.
Add a series Under Series, click Add, and then in the Excel sheet, select all the data that you want to include in the chart. When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis. You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis.
For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days. However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. On the View menu, click Print Layout.
Click the chart, and then click the Chart Layout tab. For the axis that you want to change, make sure that the axis labels show. Under Axes, click Axes, point to Horizontal Axis, and then click Axis Options. In the navigation pane, click Scale, and then under Horizontal axis type, click Date. Depending on the chart type, some options may not be available.
After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart in PowerPoint. Click the chart.
On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel. Excel opens and displays the data table for the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series. To add data to or edit data in a cell, click the cell, and then make the change. To see your changes, switch to PowerPoint. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart.
For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. Click the chart.
On the Charts tab, under Data, click Plot series by row or Plot series by column. If Switch Plot is not available Switch Plot is available only when the chart's Excel data table is open and only for certain chart types. Click the chart.
On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel. In the chart, select a data series, and then click the Charts tab. For example, in a column chart, click a column, and all columns of that data series become selected. Under Data, click the arrow next to Edit, and then click Select Data in Excel. In the Select Data Source dialog box, do one of the following. To Do this Remove a series Under Series, select the data series that you want to remove, and then click Remove. Add a series Under Series, click Add, and then in the Excel sheet, select all the data that you want to include in the chart.
When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis. You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis. For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days.
However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. Click the chart, and then click the Chart Layout tab. For the axis that you want to change, make sure that the axis labels show. Under Axes, click Axes, point to Horizontal Axis, and then click Axis Options. In the navigation pane, click Scale, and then under Horizontal axis type, click Date. Depending on the chart type, some options may not be available.
After you create a chart, you can edit the data in the Excel sheet. The changes will be reflected in the chart. Click the chart. Excel highlights the data table that is used for the chart.
A purple outline indicates a row or column used for the category axis. A green outline indicates a row or column that contains data series labels.
A blue outline indicates data points plotted in the chart. Data series labels Values for the category axis Data points plotted in the chart. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data.
In the following example, the table is expanded to include additional categories and data series. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. Click the chart.
On the Charts tab, under Data, click Plot series by row or Plot series by column. When you create a chart from data that uses dates, and the dates are plotted along the horizontal axis in the chart, Office automatically changes the horizontal axis to a date (time-scale) axis. You can also manually change a horizontal axis to a date axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months, or years, even if the dates on the Excel sheet are not in sequential order or in the same base units. By default, Office uses the smallest difference between any two dates in the data to determine the base units for the date axis. For example, if you have data for stock prices where the smallest difference between dates is seven days, Office sets the base unit to days.
However, you can change the base unit to months or years if you want to see the performance of the stock over a longer time. Click the chart, and then click the Chart Layout tab. For the axis that you want to change, make sure that the axis labels show. Under Axes, click Axes, point to Horizontal Axis, and then click Axis Options. In the navigation pane, click Scale, and then under Horizontal axis type, click Date.
Depending on the chart type, some options may not be available.