The information contained in your spreadsheet might be very valuable and useful, but it can be confusing to your audience. All those numbers, and all those facts and figures can be daunting, especially for users who do not come from a financial or a technical background.
One of the best ways to overcome this problem and give your audience the information it needs is by adding charts and graphs to your Excel spreadsheets. When you graph the financial data you have created, you make it accessible to a far wider group of people, allowing you to share that vital information with everyone at the office.
To create a chart in Microsoft Excel 2007, just follow these simple instructions:
Open Microsoft Excel and choose the spreadsheet you want to create the chart from. Highlight the cells you want to use to create the chart.
Go to the ribbon and click the “Insert” button. Click the type of chart you wish to create. You can create a number of different chart styles, including bar charts, line charts and pie charts.
Preview your chart and make any necessary changes. Click the chart and go to the “Layout” tab to change the labels for each part of the chart. Once on the layout tab, click the “Data Labels” button. Select the chart elements you want to rename, type a new name and hit the “Enter” key.