Selecting multiple columns that are not necessarily next to each other leads to incorrect chart series categories. Having the same columns next to each other and selecting all of them with single selection results in a correct chart. Make it possible for the user to make multiple selections and create charts based on them.