Exporting ICER Scatterplot to Excel

TreeAge Pro can export many graphs and other reports to Excel.

When running Probabilistic Sensitivity Analysis (PSA), one graph of interest is the ICER scatter plot. In TreeAge Pro, this graph has a straight line representing the Willingness to pay (WTP) and an ellipsis representing 95% confidence interval.

When this chart is exported to Excel, Excel does not automatically create the line or the ellipsis and only plots the points.

A TreeAge Pro modeller provided a solution to adding both the line and ellipsis in Excel.

To add the line in Excel:

• Create two columns in excel, the first to be values from the x-axis. This creates the x-coordinate for the WTP line.
• The second column values will be set equal to the WTP/value from the x-axis. This creates the y-coordinate for the WTP line.
• Select these two columns and then in the toolbar, use the Graph Design option tab and selected Layout Option 3. This is a graph with a trend line. This adds the WTP line.

To add the Ellipsis:

• Install XLSTAT,
• In Visualization, you choose scatter plot, and then choose x, y for the ellipse.
• In the Options, select Confidence Interval and set to an appropriate value to generate the ellipsis

This solution has been provided by a TreeAge Pro modeller to assist other people who might have the same question.