Change Period/Data Range

Brief

The article explains how to change the period and data range of a chart.

Details

Working with a chart, you can change either its period or data range or both of them.

To change the period, on the toolbar, in the Period box , do one of the following:

• Click the Arrow button , and then select the period of your choice from the list.
  
  
• Type the period of your choice in the following way:

1. Type the first letter of the time unit you want to use (m for minutes, h/H for hours, d/D for days, w/W for weeks, and M for months).
2. Type the number of time units of your choice (for m – 1, 2, 3, 4, 5, 6, 10, 12, 15, 20 or 30; for h/H – 1, 2, 3, 4, 6, 8 or 12; for d/D, w/W, and M - 1). For example, to set a two-minutes period, a three-hours period, a one-day period, or a one-month period, you should type m2, h/H3, d/D1, or M1 respectively.
3. Press ENTER.

To change the data range of the chart, on the toolbar, in the Period box , do the following:

1. Click the Arrow button .
2. Point to the period of the chart, and then click the data range of your choice in the list of the submenu.
   
   

Note: You can also change the data range of the chart by scrolling it. For details, see Scrolling.

To change both the chart period and data range, do the following:

1. On the Chart menu, point to Show Data Range, and then point to the period of your choice.
2. Click the data range of your choice in the list of the submenu.

Note: You cannot change the chart period to Tick. To view a tick chart, create a chart by typing or clicking T in the Period box of the Create Chart dialog box. For details, see Create Chart.

Working with a tick chart, you can change only the data range.

To change the data range of a Tick chart, do one of the following:

• On the toolbar, in the Period box , click the arrow button, and then click the data range of your choice.
• On the Chart menu, point to Show Data Range, then point to Tick, and then click the data range of your choice in the list of the submenu.

Note: You cannot change the Tick period to any other chart period. To view a chart of another period, create a chart by selecting another than Tick period in the Period box of the Create Chart dialog box. For details, see Create Chart.