Saturday, January 15, 2011

How to Create a 3


1. Open the Microsoft Excel 2010 file that contains the data you wish to make into a three-sided graph.
2. Click on any cell in your data table. Press 'Ctrl' and 'A' to select the entire table. If you need to graph only a small part of a larger table, click and hold on the top-left cell that you want to include, then drag the mouse to the bottom-right cell and release the button. Your table selection needs to include at least two rows or two columns to become a three-sided graph.
3. Click the 'Insert' tab at the top of the screen.
4. Locate the 'Charts' area of the ribbon. Click on the button for the type of chart you want to create. To make a three-sided chart, you will need to select either a 'Column,' 'Line' or 'Area' chart type. Once you click the button, a pop-up menu will appear with a number of additional chart choices. Locate either the '3-D Column,' '3-D Line' or '3-D Area' button and click it. Be aware that both the 'Column' and 'Area' pop-up menus include 3-D charts that aren't three-sided, so be sure you are selecting the button labeled '3-D Column' or '3-D Line.' Once you click the button, your three-sided chart will appear on the spreadsheet.

Blogger news