Excel guru's Urgent help

[syedasker]

I have a bunch of charts created in Excel97 that are driven from pivot
tables on another sheet. When the workbook is opened in Excel 2000
everything works fine except when you change criteria causing a macro
to
change the pivot tables, the source data range does not automatically
reset as it does in 97. I have to manually click on Source Data,
click
in the pivot table, and the range is reset, fixing the chart. I don't
know much VBA and I would like to hang a sub at the end of the macro
that would automatically reset the source range. Can someone help
with
the script?

I created a chart in excel 2002 based on pivottable on the same page
it plots the correct point but the only problem is if I change the
period from 12 months to 6 month it is not resizing the chart table it
show blanks in the rest of the months.

Thanks

 

[Jon Peltier]

It sounds like the chart series are looking for data in an unchanging
range, but the pivot table changes its size. You could set up dynamic
ranges in the sheet, and base your charts on these ranges, without the
need for attacking the charts with VBA. I have a couple of examples on
my site, plus a page full of links:
http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

- Jon

 

[syedasker]

range, but the pivot table changes its size. You could set up dynamic
ranges in the sheet, and base your charts on these ranges, without the
need for attacking the charts with VBA. I have a couple of examples on
my site, plus a page full of links:
http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

- Jon

Jon thanks for replying
Even the table size is not changing table will show the required data
but it will not select that required data instead of that it will
select everthing in the table and chart will not expands.