Expending the content of a series does not work.

Now I know what is wrong when Excel thinks "the data range is too complex to display". Then, when marking the columns to be included in the diagram, you have accidentally marked one cell too much in one column compared to the others. (A blank one at the beginning or at the end). Clearly, the data area can then be perceived as "complex".
/hans peter