nagovind
Member
Is it possible to assign the chart range dynamically based on certain conditions ?
This query is due to the handling of huge data
For e.g in certain cases there are less no. of XY coordinates that are required to be plotted in XY scatter chart
In certain cases there is a requirement to plot more no. of points in the same chart
If it is dynamically assigned then there will be resonable spped in the calculation. As the range is always linked to 1000000 cells there is a drastic slow down in the excel sheet calculation
Please advise a solution
thanks
This query is due to the handling of huge data
For e.g in certain cases there are less no. of XY coordinates that are required to be plotted in XY scatter chart
In certain cases there is a requirement to plot more no. of points in the same chart
If it is dynamically assigned then there will be resonable spped in the calculation. As the range is always linked to 1000000 cells there is a drastic slow down in the excel sheet calculation
Please advise a solution
thanks