Creating a Chart in Excel 2007:-

The first step in creating a chart is to build a worksheet that contains data to chart. Many business charts are created from summary data. If your dataset contains transactional data, you should also consider summarizing the data using either a pivot table or formulas. In the Figure (given below), the original dataset contained detailed transactional data. In order to create summary data to be used in a chart, new rows were inserted at the top of the worksheet, and a summary table was created using the new SUMIFS function. The formulas in C2:E4 create conditional sums to find the total revenue for each combination of product and year.



(The new SUMIFS function makes it easy to create the summary that can be used for charting.)