Resolve incorrect Excel bar chart legends by organizing data into three columns for proper series mapping.