Skip to content

Home / DOE / Charts / Observed vs Predicted / Options

Options

This page is the control by control reference for the dialog titled Create Observed vs Predicted Plots. What the finished chart shows is on Observed vs Predicted, and how each point is formed is on Math Details.

This is the shortest options panel in the family, on purpose. Every other chart asks which factors to plot, or where to hold the rest. This one plots every used run of whatever you tick in the Outputs tree, at that run's own settings, so there is nothing left to choose.

Outputs

The left side of the dialog is a box headed Outputs holding a tree with three levels: the worksheet, then each output on it, then each level of that output. Tick the levels you want a chart for. The dialog opens with every level on the active sheet already ticked.

The two upper levels are three-state. Ticking a worksheet or an output ticks everything under it, and clearing it clears everything under it. When only some of the children are ticked, the parent shows a partial state rather than a tick, so the tree tells you at a glance whether a selection is complete.

One worksheet at a time. Ticking anything on a second worksheet silently clears every tick on the one you had selected, and the options on the right rebuild for the new sheet. There is no warning and no way to draw charts from two source sheets in one Create.

If you press Create with nothing ticked, the dialog tells you At least one chart must be selected. and stays open.

This chart is built from a regression sheet only. Design sheets are not offered, because the chart plots a value that only a fitted model can produce.

Only a quantitative output is offered. The tree shows the output's name followed by Y-Hat and, when the output has a usable standard deviation model, S-Hat. Binary and nominal outputs do not appear: the plot they would need is a calibration plot of predicted probability against observed proportion, which is a different chart and is not built. Asking for one through any other route reports Observed vs Predicted supports a quantitative Y-Hat or S-Hat model only.

Each ticked level becomes one scatter, and they all land on one worksheet. Ticking three levels gives three plots in a grid on a single sheet, not three sheets.

The panel

This chart has no options of its own beyond the shared Outputs tree. The panel holds only a description: "Select one or more Y-Hat or S-Hat models on the left. Each becomes a scatter of the measured response (Observed) against the model's fitted value (Predicted), with a 45-degree reference line. All selected charts are drawn together on one worksheet." Every level ticked in the Outputs tree becomes one scatter in that grid; there is no separate control that changes what is plotted or how.

There is no set-point box and no axis range box, and neither is missing by oversight. A point is one run, drawn at the settings that run actually used, so there is nothing to hold constant and no range to sweep. It follows that this dialog has no numeric entry at all, and therefore none of the numeric-entry messages the other chart dialogs carry.

It also follows that the extrapolation prompt cannot appear here. Every point sits at a combination the experiment really visited, so no value can reach outside the data.

While it draws

While charts are being written, a status line reports what is happening and a progress bar appears only when more than one chart is being drawn, since a bar for a single chart would sit at 100 percent from the moment it appeared.

Cancel stops the run cleanly between charts, not part way through one. A chart that has already been written stays; the sheet that was mid-write is deleted rather than left half finished. So cancelling never leaves a partial chart behind, but it can leave fewer sheets than you asked for.

Creating with the dialog left open lets you build several charts from one set of options without reopening it. The charts are identical either way: the only difference is whether the window closes afterwards.

When nothing is drawn

If the options you chose produce no drawable chart, the dialog reports There are no valid charts selected for the report. and writes nothing. Where the reason is specific, for example an axis rule or a source restriction, that more specific message is shown instead.

The dialog is owned by the Excel window, so Excel cannot cover it while it is open. If it seems to have vanished, it is on another monitor rather than behind the workbook.

See Also