Hi guys
Banging my head against the wall here: We are helping out a client with their reporting. We extract the data using Impromptu and save it in Excel format, and then we have to create a chart from the data and put it on the same sheet. The problem is that the number of rows and columns vary from day to day. When we try to compensate for that by hard-coding a bigger selection area, the legend shows garbage, ie not the names of the columns/rows.
So, basically, we want to create a macro that will select all the data on a sheet, create a chart and place this chart on the same sheet, 2 rows below the last row of data.
Any ideas?
Banging my head against the wall here: We are helping out a client with their reporting. We extract the data using Impromptu and save it in Excel format, and then we have to create a chart from the data and put it on the same sheet. The problem is that the number of rows and columns vary from day to day. When we try to compensate for that by hard-coding a bigger selection area, the legend shows garbage, ie not the names of the columns/rows.
So, basically, we want to create a macro that will select all the data on a sheet, create a chart and place this chart on the same sheet, 2 rows below the last row of data.
Any ideas?