This example uses a simple data source based on a Human Capital Management (HCM) module employee list report. The fictional company uses SAP, and this sample report (in any form, whether a SAP query, a custom ABAP report, or something else) from SAP has been executed and is shown in Figure 21.11. The fictional report in this example contains basic information about associates and their annual pay. To follow along in your own SAP system, you can use any report that contains any data. However, it will be most meaningful if your report output has a single line for each record you want to include in the chart.
Figure 21.11. The fictional data source to be used in the example is a list of associate names, titles, and salaries.
Creating a Basic Graphical Pie Chart with Microsoft Excel
To create a basic Excel pie chart from SAP data, you follow these steps:
Open any report output screen that displays an SAP report. It can be an SAP query, a custom ABAP report, an SAP standard-delivered report, or any other format.
You have multiple options for how to get your SAP data into Excel, each of which varies depending on your installation version of SAP R/3 and your installation version of Excel. Because there are multiple options for different versions, the menu path and buttons vary for each. It is a good idea to save your SAP report output into an Excel worksheet, which you will use as your mail merge data file. The most popular way to do this is to click the Excel button on your report output toolbar. Excel launches and displays the SAP report in an Excel worksheet. Next, save the report in Excel (for example, as c:\employee_data_chart.xls). Close and exit SAP and Excel.
It is not required that you exit Excel to continue, but it is recommended that you do so from a resource perspective (how much memory your PC is using to run SAP and Excel simultaneously) and because, depending on your versions of SAP and Microsoft Office, it may be easier.
Launch Excel and open your saved data source file (for example, c:\employee_data_chart.xls). For this example, create a custom pie chart that charts each position and the annual salary associated with it. Use your mouse to highlight the appropriate columns (for example, Position and Annual Salary). With the columns selected, click the Chart Wizard button on the Application toolbar. A Chart Wizard dialog box appears, enabling you to create pictorial graphs of your SAP data.
On the Chart Wizard - Step 1 of 4 dialog, select the Custom Types tab, and then select Pie Explosion from the Chart Type list (see Figure 21.12). Click Next.
Figure 21.12. This tab displays the user-defined and built-in custom chart types that Microsoft Excel provides.
Click the Next button on each of the next two wizard dialogs without making any changes.
In the Chart Wizard - Step 4 of 4 dialog, select the In a New Sheet option, and then click the Finish button. A new Microsoft worksheet is created, with your pie chart inserted in it (see Figure 21.13).
Figure 21.13. The chart is as large as the worksheet, and you can save it as a separate workbook.
When you finish your Excel chart, you can edit or print it. To learn more about these operations, visit www.support.microsoft.com and search for "Microsoft Excel Chart Wizard."