Excel 2008: Create a Chart or Graph Step 1 - Reassign F11 - Pressing the F11 key on a Macintosh will minimize all applications, displaying the desktop. Pressing the F11 key can be used to create a quick graph, but you must first reassign the function assigned to that key. From the Apple menu, select System Preferences and then select Expose & Spaces. Click on the right end of the Show Desktop area and select something other than F11. If you want a quick way to see the Desktop select something other than the dash.
Step 2 - Data entry - Enter data collected with your survey. For this example I took a survey of my class asking them to name their favorite fruit. Data can be entered without the headings I entered in row 1.
Step 3 - Creating the chart - Note: this chart will be created without using the Chart Wizard. When data has been entered and your cursor is immediately below the entered date, press the F11 key on the top row of your keyboard.
This is from Microsoft regarding macro's in Excel 2008 for Mac With Excel 2008, you can continue to use and maintain Excel 4.0 macros (XLM macros) that have not been upgraded to Visual Basic® for Applications (VBA). Although you cannot record new Excel macros in Excel 2008, you can run and modify them.
Step 4 - Viewing the Charts Gallery - There are things that you probably wish to change about the chart. The new Office 2008 allows you to quickly make those changes.
![Tutorial Tutorial](/uploads/1/2/5/4/125417451/538546861.jpg)
As soon as the chart is created click on the Charts tab immediately above the chart. From that tab you can scroll through each of the chart types and make a selection (This image has been simplified to fit the page) Step 5 - Using the Formatting Palette - Several areas on the palette can be used to make changes.
Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data. Select the data you want to chart. Click the Insert tab, and then do one of the following:. Click Recommended Charts and select the chart type you want. OR. Click a specific chart type and select the style you want.
With the chart selected, click the Chart Design tab to do any of the following:. Click Add Chart Element to modify details like the title, labels, and the legend. Click Quick Layout to choose from predefined sets of chart elements. Click one of the previews in the style gallery to change the layout or style. Click Switch Row/Column or Select Data to change the data view. Click Change Chart type to switch to a different kind of chart.