On 2002-04-27 06:52, Aladin Akyurek wrote:
On 2002-04-27 06:22, saurabh_sharma wrote:
Thanks for the help.
I am facing an issue with the file below.
I need to draw a graph for GCVB ids for the diff. Dates for the diff parameters. I have tried using the pivot table but as the data is to be increased everyday so possibly a v lookup would help.
Pls. advise and help wit this…
calls contacts
4/25/02 GCVBMVT 10554 9497
4/25/02 GCVBSFT 7471 6483
4/25/02 GCVBMVT 10554 9497
4/24/02 GCVBIUT 607 537
4/24/02 GCVBIPT 11993 10859
4/24/02 GCVBKGT 5873 5085
4/24/02 GCVBIZT 10865 9958
4/23/02 GCVBIUT 607 537
4/23/02 GCVBIPT 11993 10859
4/23/02 GCVBKGT 5873 5085
4/23/02 GCVBIZT 10865 9958
4/23/02 GCVGSBT 4749 4255
4/23/02 GCVGVFT 9350 8428
4/23/02 GCVBIKT 8135 7319
4/23/02 GCVBPET 7954 7157
4/23/02 GCVBMZT 10426 9353
4/23/02 GCVBMWT 5935 5270
4/23/02 GCVBPAT 9740 8723
4/23/02 GCVBMVT 10554 9497
If you're going to create a pivot table from your data, you better use a dynamic name range and give this name as
Range to the Wizard.
I'll assume the sample above to be in A1:D20 including labels/column headings in a worksheet called
Data.
Activate Insert|Name|Define.
Enter
Nrecs as name in the Names in Workbook box.
Enter as formula in the Refers to box:
=MATCH(9.99999999999999E+307,Data!$A:$A)
Note that this formula uses your dates column.
Activate Add. (Don't leave yet the Define Name window.)
Enter
Drange as name in the Names in Workbook box.
Enter as formula in the Refers to box:
=OFFSET(Data!$A$1,0,0,Nrecs,4)
Note that 4 indicates how many columns your data area covers.
Activate OK.
Now give
Drange as value of
Range in PivotTable Wizard.
The above allows you to add to or delete from your data area as many records as you wish. At refresh PivotTable will know the new range.
Aladin