I have attached the excel file, which has chart in “CHART” sheet and the corresponding data is in “Data” sheet. Even though the data area is pointed to grid in “Data” sheet its not painting the chart correctly.
If I modify the values in grid to lower values the chart is painting rightly. Could you please throw some light on it.
Is there a way to set auto scale for the values so that it draws the chart proportionately?
Please let me know if I am not clear.Excel sample.zip (46.3 KB)