Understanding Headers & Grouping

When a spreadsheet gets more complex, then you will need to give RitchViewer some simple help describing data boundaries.

RitchViewer Excel Menu Bar

Header Basics

Manage Headers Workbook example

For this sheet we had to tell RitchViewer where the Row Header andColumn Labels were. To do this:

  • We selected a point in Row 8 and pressed the Row Header button.
  • We selected a point in Column A and pressed the Column Header button.

To examine where RitchViewer is getting its boundaries,  click on the cell of interest then press the Manage Headers button.

 

 

 

 

 

You can then [Show] the areas used by the chart.