Steps to Manually Re-Scale the Y-Axis in the PQ Kit Template
Note, Residual graphs are not automatically set to scale of the data entered. As such, the Y-axis default settings may be out of ratio for the data values entered. By manually re-scaling the Y-axis, it will reflect your values for a more effective visual ratio.
Please use the following instructions to format and scale the Y-axis of graphs in the MicroSolv HPLC PQ Kit Excel Template :
- In the Detector Linearity Tab of the PQ RID Spreadsheet, right click on the Detector Linearity Residual Graph.
—
- This will open a tab of options. Click “Format Plot Area.”
—
- This opens a new Grey Tab to the right of the screen, labeled, “Format Plot Area.” Click the Blue arrow next to the “Plot Area Options.”
—
- Next, click the ‘Graph’ icon.
—
- This will open a list under “Plot Area Options.” Click the “Vertical (Value) Axis” option.
—
- This will open a tab to “Axis Options.” Then Check “Reset” on both the Minimum and Maximum Bounds.
—
- Then Check “Reset” on both the Major and Minor Units.
—
- Your new graph should now be to scale and display all data points.
—