Remove backgrounds or add color filters to your photos right within PowerPoint. Increase efficiency and save time by automating repetitive tasks using Visual Basic. View, edit, store, and share spreadsheets online with the Excel Web App on Windows Live SkyDrive.* Share and coauthor Excel spreadsheets with virtually anyone, whether they're using Office on a Mac or PC. Buy word for mac student. PowerPoint for Mac 2011 Create powerful, professional presentations that engage and inspire your audience, and present online as effectively as in person. I’ve tested this on Excel 2003, Excel 2007, Excel 2010, Excel for Mac 2011, Excel 2013 and the version included with Microsoft Office 365 (Including the online version). Enough with the technicalities, lets move on to the reason why you came and learn how to change the color of a series in Excel. Creating Graphs in M icrosoft Excel Graph One Step1: Continuing on from the table, create a new work sheet Step2: Rename both the sheets. Sheet with the table name Amour Cafe and the sheet that will have graphs, call it graphs. T o do this double click on the sheet part down the bottom. Step3: T o get chart options up, go to the top tool bar across to insert, then go down to chart. Click chart and options will appear. (Options are the different charts available to use). Jacqueline McAlister Click the + symbol at the bottom of. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |