How to Create Graphs in Excel with Multiple Columns

by Emma Hurley

Spreadsheets are a way of arranging and analyzing numerical data. Once the raw data has been organized, it can be turned into charts with a few clicks. A graph can summarize large amounts of information and demonstrate trends instantly. A stacked chart shows each series divided into multiple columns and can be displayed numerically or in percentages. The most commonly used stacked chart is a column; for this example a 2-D stacked chart will be used.

1

Enter the data for the desired chart into an Excel spreadsheet. Title any columns or rows as required.

2

Highlight all data you wish to include in the chart. To highlight cells, click your mouse, and while holding down, drag it to include all desired information.

3

Click the "Insert" tab, and in the charts group, click "Column." Select the 2-D stacked column chart and it will be generated automatically.

4

Edit the layout and style of the chart, label the various components and edit the size of the chart by clicking on the chart to generate a chart tools tab with three sub-tabs of design, layout and format.

5

Save your work by clicking "File" then "Save As" and a window pops up. Insert a name for the file and click "Save."

Tips

  • check This information is specific to Microsoft Excel 2010, but the principles can be used in other spreadsheet programs.
  • check Take time to experiment with the different graphs to ensure you have selected the most appropriate one.
  • check Save your work often.

Items you will need

About the Author

Based in London, Emma Hurley has been writing step-by-step computer guides since 2008. She has worked for an international food manufacturer as a financial analyst, and obtained a Bachelor of Science in accounting and finance from the University of Southampton.

Photo Credits

  • photo_camera Stockbyte/Stockbyte/Getty Images