Thursday, October 25, 2012

How to Create Graphs Embed in Spreadsheets


1. Open the saved Excel worksheet.
2. Click and drag to select the range of data for the chart. For example, select the categories and the values to appear on the chart.
3. Click the 'Insert' tab on the command ribbon.
4. Click the preferred 'Chart' button on the 'Charts' group. Click the window launcher arrow in the group's bottom right corner to open a more extensive chart list. A chart appears over the worksheet. The 'Chart Tools' ribbon appears with additional format options.
5. Click the preferred formats on the various ribbon tabs, such as 'Design,' 'Layout' or 'Format.' Create a custom look by changing the color and font for the plot area and the chart area, for example.
6. Save this Excel file.

Blogger news