Creating tables in Microsoft Word used to be so annoying that most people just did it in Excel, then imported it into Word. It’s worth giving Word 2013’s table tools a try, though, because the process is easier, and there are some new graphical options.
In this section, we’ll show you the steps to create a pie chart in Excel 2011 for Mac. While the images may differ, the steps will be the same for other versions of Excel, unless they are called out in the text.
If you don’t need to make a data visualization, you can also create a table in Excel using preexisting data. There are two ways to format a data set as a table:
Manually: In this example, we manually added data and formatted as a table by including column and row names (products and years).
Use Excel’s Format as Table Preset: You can also input raw data (numbers without any column and row names).
Once you input your data and select the cell range, you’re ready to choose your chart type to display your data. In this example, we’ll create a clustered column chart from the data we used in the previous section.
To generate a chart or graph in Excel, you must first provide Excel with data to pull from. In this section, we’ll show you how to chart data in Excel 2016.