Friday, May 11, 2012 9:49 PMWe need to use a hyperbolic curve in displaying our data set. Excel 2010 does not have this, and we do not want to use a Vendor add-in: has Excel updated this option and can we get it in a Template from a Gallery?
Monday, May 14, 2012 7:05 AMModerator
Based on my research, here’s an example:
1. Start Excel 2010
2. Enter data for curve in two columns. After data is entered, select both columns of data and click on Insert-Charts-Scatter-Scatter with only Markers. This is the Chart Wizard. Click on the Chart Title and type Rate Time Curve. Next place the Horizontal Axis Title. Click on the Chart to display the Chart Tools. Navigate Chart Tools-Layout-Axis Titles-Primary Horizontal Axis Title-Title Below Axis. Select the Title and type t(Months). Next place the Vertical Axis Title. Click on the Chart to display the Chart Tools. Navigate Chart Tools-Layout-Axis Titles-Primary Vertical Axis Title-Rotated Title. Select the Title and type q(BOPD).
3. Extrapolate data with a trendline curve. Click on chart to select it. A tab Chart Tools will appear on top of the toolbar ribbon. Click Chart Tools-Layout-Analysis-Trendline-Exponential Trendline and a curve will appear on the graph. To extend the horizontal axis on the graph click on the graph and navigate Chart Tools-Axes-Axes-Primary Horizontal Axes-More Primary Axis Options-Axis Options. Be sure Auto is selected for all buttons. Now we will extend the curve by double clicking on the curve to get the Format Trendline box. A dot should be in front of Exponential. In the box by Forecast-Forward put 8.0 periods. A check should be in front of the Display Equation on Chart and Display R-squared value on chart. Press Enter to update chart.
TechNet Community Support
- Marked As Answer by Jaynet ZhangMicrosoft Contingent Staff, Moderator Thursday, May 17, 2012 3:13 AM