John Focht
New Member
I need help with creating a dynamic chart with non-contiguous data. I can't get the functions in the example from
http://chandoo.org/wp/2012/12/04/fo...ting-dynamic-charts-with-non-contiguous-data/
to work.
I have data being 'dumped' from a specialized database program into Excel. It has to be organized and collated first. The dumped data is put in worksheet 'Total Results' and organized via a VLOOKUP call into 'Organized Results'. Now I need to plot the data at a given depth interval, say more than 3 feet deep and less than or equal to 4 feet deep, as a function of position across a section of roadway. (This will need to be done for every chosen depth interval to a depth of up to 20 feet. The intervals were chosen so that only one value will occur in each interval i.e. there will not be values at both 3.5 and 4 feet, only one value - or no value.) For this exercise, 'A' values are on the left shoulder and 'F' values are on the right shoulder, with left-to-right positions in alphabetical order. (This will not always be the case.) (A through F shown in column C of 'Organized Results.')
Can someone look at my spreadsheet and help me? I will have between 5,000 and 10,000 data points when our lab is finished. And I don't have weeks to create these graphs manually. All help is deeply appreciated.
http://chandoo.org/wp/2012/12/04/fo...ting-dynamic-charts-with-non-contiguous-data/
to work.
I have data being 'dumped' from a specialized database program into Excel. It has to be organized and collated first. The dumped data is put in worksheet 'Total Results' and organized via a VLOOKUP call into 'Organized Results'. Now I need to plot the data at a given depth interval, say more than 3 feet deep and less than or equal to 4 feet deep, as a function of position across a section of roadway. (This will need to be done for every chosen depth interval to a depth of up to 20 feet. The intervals were chosen so that only one value will occur in each interval i.e. there will not be values at both 3.5 and 4 feet, only one value - or no value.) For this exercise, 'A' values are on the left shoulder and 'F' values are on the right shoulder, with left-to-right positions in alphabetical order. (This will not always be the case.) (A through F shown in column C of 'Organized Results.')
Can someone look at my spreadsheet and help me? I will have between 5,000 and 10,000 data points when our lab is finished. And I don't have weeks to create these graphs manually. All help is deeply appreciated.
