Tuesday, January 15, 2013

How to Create Graphs in Excel with Multiple Columns


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.'

Blogger news