Home MS Excel 2007 Charts and Graphics

Charts and Graphics



Excel is the most commonly used software for creating charts. Charts depict data visually, so you can quickly spot overall trends. They're a fabulous way to help you find the meaning hidden in large amounts of data. 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.

Excel's charting tools are enormously flexible: You can generate a simple chart with standard options in a couple of mouse clicks, or you can customize every aspect of your chart's appearance (including colors, scale, titles, and even 3-D perspective). This tutorial takes the first approach and explains how to generate straightforward charts. You'll also learn which chart types are out there, and how to fine-tune your charts for maximum effect.

You'll learn how Excel charts work and how you can transform ordinary tables of information into graphical representations, complete with columns, bars, lines, and even bubbles. You'll start by looking at how you can use basic formatting techniques to change the color and font of different chart components. Then you'll learn how to set a chart's scale, unleash 3-D views, and make your data stand out no matter what type of chart you use.

Learn how to use Excel's graphics capabilities to display your data in a chart, charts techniques, charts styles and layouts, adding; selecting and formatting the charts elements and how to use Excel's other drawing tools to enhance a worksheets like Picture Handling, Clip Art, Shape Drawing (and fancy text) and Smart Art.