I can't find an easy way to do this for ALL the data series in a chart.Say I have100 students5 different colleges at the university the students could attend, some might double major and attend ...

Key Takeaways : Organize your data with tasks and dates in two columns, and a height column with alternating values. Select date and height columns, then insert a 2D column chart. Add data labels ...

From organizing your data and calculating totals to customizing the chart’s design and adding dynamic labels, Chandoo’s guide covers it all.

While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.