Re: chart range selection

Depending on how the data are arranged, you could AutoFilter for the
dates you want to show, or create a dynamic chart.

A) You can create a chart from all the data, then filter the data to see
individual results.

1. Select all the data, and create a chart
(it will be very crowded, but just ignore that)
2. Locate the chart on a separate sheet, or place it above the chart
data. Or, select the chart, choose Format>Object, and set its properties
to 'Don't move or size with cells'
3. Select a cell in the chart data
4. Choose Data>Filter>AutoFilter
5. From the dropdown list in the Name column, select a name
6. The chart will show only that individual's data.

Note: This technique will work if the chart is set to plot visible cells
only (select the chart, choose Tools>Options, Chart)

B) Create a dynamic chart
There are some instructions on Jon Peltier's web site:

http://www.geocities.com/jonpeltier....html#DynColCht

bayanbaru wrote:
> I have a table showing the productivity performance from
> Jan 2002 to Jul 2003. I have the chart plotted out from
> Jan 2002 to Jul 2003. However how do I have the option to
> select the time range just to show the performance from
> Jan 2003 to Jul 2003 and when the need arises I can revert
> to show Jan 2002 to Jul 2003?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html