Rescaling graphs in the MicroSolv HPLC PQ Kit Excel template - Tips & Suggestions
December 8, 2021
/
/
/
/
/
/
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 :
  1. In the detector linearity tab of the PQ RID spreadsheet, right click on the detector linearity residual graph.
    ---
  2. This will open a tab of options.  Click "Format Plot Area."
    ---
  3. 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."
    --
  4.  Next, click the 'Graph' icon.
    --
  5. This will open a list under “Plot Area Options.” click the "Vertical (Value) Axis" option.
    ---
  6. This will open a tab to “Axis Options.” Then Check “Reset” on both the Minimum and Maximum Bounds.
    ---
  7. Then check “Reset” on both the Major and Minor Units.
    ---
  8. Your new graph should now be to scale and display all data points.
    ---

Related Articles

  1. Are column oven temperatures qualified by the HSQ Kit for HPLC - FAQ
  2. Can I use the certified HPLC column supplied in the HSQ Kit for UHPLC performance qualification - FAQ
  3. Can I use the HSQ Kit for Installation Operational or Performance Qualification - FAQ

© Copyright 2025. MICROSOLV. All Rights Reserved. Website & Hosting by BlueTone Media