asingh
02-17-2008, 05:29 AM
Hi,
I have a sheet which has around 5 data grids on it.
Say: Column A has City names, Column B has a calculated number, and Column C has the % contribution of the column B number overall. And my graphs are bound to column A and Column C. After the sheet calculates I want the Graph to show the values in Descending order..somewhat like a pareto graph. To do this I sort the whole data grid based on column C (%) - in descending order. To get the graph to update I have to recalculate the sheet. Now one recalculation is taking around 8 minutes.
Is there anyway that after the sorting is done (will write the code for this) -- that I dont need to force another recalculation on the sheet, and the graphs update after after the grids have been sorted as per %. The "charts" object does not have any refresh/update property. But "active chart" does...this way I will have to select each chart..!!
thanks and regard,
asingh
I have a sheet which has around 5 data grids on it.
Say: Column A has City names, Column B has a calculated number, and Column C has the % contribution of the column B number overall. And my graphs are bound to column A and Column C. After the sheet calculates I want the Graph to show the values in Descending order..somewhat like a pareto graph. To do this I sort the whole data grid based on column C (%) - in descending order. To get the graph to update I have to recalculate the sheet. Now one recalculation is taking around 8 minutes.
Is there anyway that after the sorting is done (will write the code for this) -- that I dont need to force another recalculation on the sheet, and the graphs update after after the grids have been sorted as per %. The "charts" object does not have any refresh/update property. But "active chart" does...this way I will have to select each chart..!!
thanks and regard,
asingh