Menu
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.
You CAN type new numbers, but they become “dead.” To update Excel from within the Word document, right click on the table and choose Linked > Open Link (as shown above). The Excel file will open in Excel where you can edit directly. Changes that you make will show up immediately in Word FOR THE CELLS YOU ARE EDITING ONLY. After failing to figure it out on my own or find any relevant info on the internet, I had to copy/paste my data into excel and do it from there. Does anybody know how I can do this in numbers? Obviously excel works just fine but I like the aesthetics and the simpler formatting options of the graphs that I get using numbers.
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.
Related Articles
- 1 Round Up to the Nearest 10 in Excel
- 2 Forward an Email From an iPad
- 3 Graph Fourier Series in Excel
- 4 Create a Listbox in VB From an Excel Spreadsheet
Excel allows you to add charts to enable others to visualize the data you're presenting. Because there are a variety of charts available, such as line and bar, determine the best chart style to suit the type of data you want to display, then customize your chart by adding a trendline to draw attention to a trend in the displayed data. While trendlines typically reach from the initial data point to the last, you can extend them beyond these spots.
1.Launch Excel and open the spreadsheet that contains the chart with the trendline that you want to extend. Click the trendline to select it.
2.Click the 'Layout' tab and locate the 'Analysis' group. Click the 'Trendline' button and select 'More Trendline Options.' This opens a separate window.
3.Click the 'Options' tab. Click the 'Up' arrow in the 'Forward' field to select an increment to extend the trendline to the right. Click the 'Up' arrow in the 'Backward' field to select an increment to extend the trendline to the left. Click the 'OK' button to apply the change to the trendline.
References (1)
About the Author
Cooper Temple has over 15 years of experience writing procedural and training material for a Fortune 500 company. His articles specialize in productivity programs and other business-related software.
Photo Credits
- Comstock Images/Comstock/Getty Images
Choose Citation Style
Temple, Cooper. 'How to Extend a Trendline on Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/extend-trendline-excel-27943.html. Accessed 15 December 2019.
Temple, Cooper. (n.d.). How to Extend a Trendline on Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/extend-trendline-excel-27943.html
Temple, Cooper. 'How to Extend a Trendline on Excel' accessed December 15, 2019. http://smallbusiness.chron.com/extend-trendline-excel-27943.html
![How How](https://cdn.extendoffice.com/images/stories/doc-excel/best-fit-curve-equation/doc-best-fit-curve-equation-2.png)
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.