When selecting Source Data for a chart in Excel there's a "Chart Data Range" field. But in the "Legend Entries (Series)" there are also one or more series ranges. What is the point of the "Chart Data Range" if you have to explicitly define the series ranges anyway? If there are some columns in "Chart Data Range" that are not in any series, does that matter?