HomeTroubleshootingAll Products: Other Issues"The specified dimension is not valid for the current chart type."

3.26. "The specified dimension is not valid for the current chart type."

Applies to: Graphs in all 6.x products (not 7.x)

When I try to create some kinds of graphs in @RISK (PrecisionTree, ...), I get a blank graph and this error message:

The specified dimension is not valid for the current chart type.

There could be different symptoms, such as a message "Method '~' of object '~' failed", or just a blank worksheet with no chart and no message. The common thread is an attempt to have Palisade software create an Excel chart.

Excel refuses to create charts of some types if the default Excel chart type is one of the more complex ones. To fix this, either upgrade your Palisade software to the current release, or set your default chart to a simpler type, such as Clustered Column (Excel's original default) or Line.

In Excel 2007 and Excel 2010:

  1. Click the Insert tab in the ribbon. (It doesn't matter whether you have data pre-selected.)
  2. In the Charts section, click the tiny arrow in the bottom-right corner. An Insert Chart dialog opens.
  3. Select Column in the left panel, and then in the right panel click the first chart.
  4. Click the "Set as Default Chart" button, and then click Cancel. This sets the default chart type without actually creating a chart.

In Excel 2013 and 2016:

  1. Select a cells that contains a number. Click the Insert tab in the ribbon.
  2. In the Charts section, click the "See All Charts" button, which is the tiny arrow in the bottom-right corner. An Insert Chart dialog opens.
  3. Click the All Charts tab in the dialog.
  4. Select Column in the left panel. Then, in the right panel, right-click the first column chart and select "Set as Default Chart".
  5. Click Cancel. This sets the default chart type without actually creating a chart.

There's no need to close and reopen Excel or the Palisade software; you'll be able to create your chart now.

Acknowledgement: This article at ExcelBanter.com explains the source of the error message.

See also: There are other possible causes for "Method '~' of object '~' failed". See All Articles about "Method '~' of object '~' failed".

Last edited: 2017-02-17

This page was: Helpful | Not Helpful