Programatically set chart data range... RRS feed

  • Question

  • Hi,

    Need help with chart thing. In Sheet 1 i got a chart with its data range in sheet 2. So, whenever I import text files, the data from the text files are stored in sheet 2, and accordingly the data range from sheet 2 is used to display chart. So, how to programmatically select all the data. Cause first time if i select 5 text files, the chart is displayed according to those 5 files data (this is done manually), but next time when i select 8 text files, it shows only data range for the first selection, i.e., for 5 text files data. Is there any way to select the data range for that chart till last row and display the chart, no matter how many files i select.

    My columns are like this.

    sample table format is here

    Date Amount 1 Amount 2 Total
    20140523 200 50 250
    20140524 140 100 240
    20140630 400 130 530
    20140805 200 98 298
    20140806 150 98 248

    Also how to change column 1 data to date format?


    Tuesday, October 7, 2014 10:44 AM


All replies