Preventing Null values from plotting in Excel Charts.
I am working on creating a report on data that is constantly changing. I want to plot the only cells with records. In the attached spreadsheet, if i click on column B7 to show Group 1, there are 21 records that needs to be plotted. If i click on B7 to select Group 2 there are 6 records to be plotted. For group 2, I want to delete or hide cells that are not populated and only plot the cells that are populated with data. I am thinking this can be accomplished using vba. My goal is to create 2 separate reports for Group 1 and Group 2
e.g. the formula in C13 should be like below......
Open in new windowChange all the formulas in the same way for column D,E,F,J,K,L and M.