Charts are a strongpoint in Excel for Mac 2011. Students, businesses, scientists, news organizations, economists, and many other groups use charts. When you make charts in Office 2011 for Mac, you find a brand-new set of Chart tabs on the Ribbon that guide you with the latest Microsoft charting technology.
What key combination do I have to press to create a line break in a cell in Excel for Mac 2011? The Windows combination of Alt+Enter does not work on the Mac. Keyboard ms-office. Active oldest votes. The answer is to use Control+Option+Enter, which will create a line break in the cell. As an alternative, Control+Command+Enter can.
If you have some data to chart, by all means use it as you go through these examples. Typing in the data was the hard part. Now for the easy part: making the chart!
- Select a cell in the data range.
- On the Ribbon’s Charts tab, go to the Insert Chart group and then choose a chart type.A palette displays, showing various subtypes of charts. Choose one you think will display your data well. Excel figures out the boundaries of the data range and instantly displays your chart. To follow with the example, choose Line→2-D Line→Marked Line.
If the chart looks wrong, chances are Excel’s guess about which rows and columns to use for the axis was wrong. It’s a 50-50 proposition. To fix this problem, on the Ribbon’s Charts tab, locate the Data group and choose whichever Switch Plot button is not selected to switch row and column data source.
When you select a chart, the Chart menu activates, the data range is highlighted, and you have three extra tabs on the Ribbon to enjoy: Charts, Chart Layout, and Chart Format. You can right-click individual chart elements like series, plot area, legend, and so on to display pop-up menus that lead to more formatting options. If you’re into designing great-looking stuff, welcome home!
When you make Excel charts in Office 2011 for Mac, you find a brand-new set of Chart tabs on the Ribbon that guide you with the latest Microsoft charting technology. Excel 2011 for Mac offers real power in its chart-analysis tools, but using them requires some knowledge of the math behind the features.
Adding a trendline to charts in Excel 2011 for Mac
Excel can add a line called a trendline that calculates and projects the trends into the past or future indicated by your data.
Used improperly, a trendline can present a false picture of what’s going on with your data, so make sure you and your audience are clear about the calculation choices you made to produce your trendline.
It’s best to start with a line or bar chart. Not all chart types support trendlines. Using a single data series makes your chart much easier to understand. To add a trendline, choose the Trendline option from the Chart Layout tab of the Ribbon. This brings up the Trendline gallery with options to choose from.
Adding drop lines and high-low lines to charts in Excel 2011 for Mac
Two special kinds of lines can be added to your line chart: drop-lines and high-low lines.
On the Ribbon’s Chart Layout tab, go to the Analysis group and choose Lines→Drop Lines to add lines from your data points to the X-axis.
Hi-low lines connect the highest value and lowest value of each data point with a line. In the Chart Layout tab’s Analysis group, choose Lines→High-Low Lines to add these.
Adding up-down bars to charts in Excel 2011 for Mac
Up-down bars automatically highlight the differences between the topmost and second topmost values of your chart. On the Ribbon’s Chart Layout tab, go to the Analysis group and click Up/Down Bars to turn these on or off. Double-click one of the bars to display the Format Up Bars dialog, where you can customize these bars.
Adding Error Bars to charts in Excel 2011 for Mac
In the Chart Layout tab’s Analysis group, click Error Bars to display a pop-up menu where you can choose from standard error, percentage, or standard deviation to add error bars.
Double-click an error bar to display the Format Error Bars dialog. You can format your error bars in this dialog. You can specify custom error values by clicking the Specify Value button and choosing cells.