There’s been a lot of articles written on the new features available and the integration of PowerPivot and Power View has really got everyone talking about. In the next chapter, you’ll learn how to fine-tune your charts for maximum effect.There has been a lot of buzz in the BI community since yesterday, and the reason is none other than the public preview of Office 2013 (Excel 2013 in particular). You’ll also learn which chart types are out there. This chapter takes the first approach and explains how to generate straightforward charts, which you’ll examine in detail. You can create many different types of charts in Excel, including pie charts that present polling results, line charts that plot rising or declining assets over time, and three-dimensional area charts that show relationships between environmental conditions in a scientific experiment.Įxcel’s charting tools are enormously flexible: You can generate a simple chart with standard options with a couple of mouse clicks, or you can painstakingly customize every aspect of your chart’s appearance (including colors, scale, titles, and even 3-D perspective). They’re a fabulous way to help you find the meaning hidden in large amounts of data.

And one of the best ways to do that is with Excel’s charting tools.Ĭharts depict data visually, so you can quickly spot trends. Instead, the real work lies in analyzing your data-in figuring out a way to tell the story that lies behind your numbers.

As you become more skilled with Excel, you’ll realize that entering numbers, organizing your layout, and formatting cells aren’t the most important parts of spreadsheet creation.

How to create pie chart in excel 2013