KB31065: A Trendline from a MicroStrategy Developer 9.x/10.x graph report is different than the one generated in Microsoft Excel

SYMPTOM:
Users notice that the Trendline in a graph looks different in Microsoft Excel to the one generated in Strategy Developer 9.x/10.x as shown in the images below:
 
Strategy Developer 9.x

Microsoft Excel

 
STEPS TO REPRODUCE:
Execute in Strategy Tutorial:
 

• Create a simple report with the Quarter and Day attributes in the rows, and the metric Units Sold in the columns.  Add a Report filter where Quarter = 2006 Q1 as shown in the image below:
  

• Run the report as a Vertical Line: Absolute Graph.
• Right click on the graph and go to the Graph Preferences -> Options -> General and set the Maximum number of categories to 200 as shown in the image below:
  

• Go to Series -> Units Sold -> Trendline and set the following settings:
  a. Regression Type: Polynomial
  b. Order: 3
  c. Enable “Show Equation” as shown in the image below
  

• Execute the report and the Graph should look like below:
  

• Export the Strategy Grid results to Excel as shown below:
  

• In Microsoft Excel highlight the results and go to the Menu toolbar Insert -> Line as shown in the image below:
  

• Highlight the Series and select “Add Trendline…” as shown below:
  

• From the Format Trendline windows, select Polynomial, set Order to 3 and check “Display Equation on chart” as shown below:
  

• Now the graph should look similar to the image below:
  

 
CAUSE:
Microsoft Excel and Strategy Developer 9.x/10.x calculate the Trendline differently. 
 
ACTION:
In Microsoft Excel:

• Go to the Format Trendline window, check the Set Intercept value to whatever the constant value from Strategy is, in this case the value is 2.67 as shown in the image below:
  

• The Trendline within the graph in Strategy Excel now should look the same than the one in Strategy Developer as shown in the image below:
  

Note: The formula may still show different due to the decimal values, but the result now should be the same.