• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charting Non Contiguous Column Data

Will2016

New Member
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/
 

Attachments

  • dataset 10.19.16.xlsx
    130 KB · Views: 7
Back
Top