Set Intervals on a Category Axis Open the Excel 2010 spreadsheet where your chart is located, then click anywhere on the chart. Click the "Format" tab at the top of the screen.

If you are interested in learning more about how you can manage data categorization in Excel while preserving historical values, a concept known as a “slowly changing dimensions” (SCD). Managing and ...

You can set the print area of an Excel spreadsheet using the Print Area button to print only a selected area of a spreadsheet.