I sat my Expert exam the other day, but failed ultimately on the section 'Advanced Charts.' The question that got me really stuck was asking me produce a combo chart (never said what type though which was confusing as well, e.g stacked column etc), but you had to edit the series data. So for that I just went Design > Select Data. Seemed simple. But it was asking for the Legend Entries to be Duration and Country, and the horizontal label to be something such as Date, but ONLY data with the name matching "Strata" could be shown in the chart. Again, I had no idea how to do this, because the Name field (containing the "Strata" name along with others could not be added, so I assume some function needed to be added to each series, but I had no idea what to do. e.g I was thinking like IF the cell in the selected range is == to the name THEN use this cell in the series, but had no idea how to do this.
EDIT: Forgot to add, simply filtering by hiding the rows where "Starta" was not present, was no possible due to the table of data having 299 entries, thus being somewhat time consuming in doing this method.