I am looking for an example of how to Comb Chart Non-Contiguous Data from a worksheet
that only has data in Columns B through I, $b$4:$i$299. Selecting the separate columns is
easy (e.g., Column D and H), but what about when you only need cells labeled "Adjacent"
from one column and the dates that coincide with "Adjacent" from a worksheet.
You can sort because of test restrictions.
Every example I find is so perfect with vertical values in Column A.
The link below is similar except that the data is from rows. I need a Combo chart from
Columns only with no Vertical Values (see attached spreadsheet).
http://chandoo.org/wp/2012/12/04/fo...ting-dynamic-charts-with-non-contiguous-data/
that only has data in Columns B through I, $b$4:$i$299. Selecting the separate columns is
easy (e.g., Column D and H), but what about when you only need cells labeled "Adjacent"
from one column and the dates that coincide with "Adjacent" from a worksheet.
You can sort because of test restrictions.
Every example I find is so perfect with vertical values in Column A.
The link below is similar except that the data is from rows. I need a Combo chart from
Columns only with no Vertical Values (see attached spreadsheet).
http://chandoo.org/wp/2012/12/04/fo...ting-dynamic-charts-with-non-contiguous-data/