Microsoft Office Tutorials and References
In Depth Information
Practical Charting
Practical Charting
You can also print an embedded chart on a separate page, which is surprisingly easy.
Just click the chart to select it, and then choose File Print. When you do so, Excel’s
standard choice is to print your chart using landscape orientation, so that the long
edge of the page is along the bottom, and the chart’s wider than it is tall. Landscape
is usually the best way to align a chart, especially if it holds a large amount of data,
so Excel automatically uses landscape orientation no matter what page orientation
you’ve configured for your worksheet. Of course, you can change this as you would
with any other printout; just choose Portrait Orientation in the list of print settings
before you click the big Print button.
Excel also includes two print options that are specific to charts. To see these options,
click the Page Setup link at the bottom of the list of print settings. When the Page
Setup dialog box appears, choose the Chart tab. You’ll see an option to print a chart
using lower print quality (“Draft quality”), and in black and white instead of color
(“Print in black and white”).
Standalone charts
If you’re using a standalone chart, your chart always prints out on a separate page,
sized to fit the whole page. To print out just the chart page alone (rather than the
whole workbook), switch to the chart’s worksheet, and then choose File Print. Excel
automatically sets all chart worksheets to Landscape orientation, which orients the
page so that the long edge runs horizontally across the bottom. If this layout isn’t what
you want, change the orientation setting to Portrait Orientation before you print.
If you want to print the entire workbook, choose File Print from any
worksheet. Then, change the first print setting from Print Active Sheets to Print Entire
Workbook.
Practical Charting
Figure 19-1 showed how to chart a list that contains two columns you want to
graph—one with text labels and one with numeric data. But, in real life, you’ll
probably need to deal with many types of data that occupy many different configurations
on your worksheet.
Consider all the possible variations on that simple two-column sales chart. You may
need to compare the sales figures but, rather than showing region-to-region
comparisons, you want to show how well (or poorly) each of your firm’s products sold.
Or perhaps you want to chart the quarterly performance of different stores over a
five-year period, or determine the relationship between sales and profitability. All
these charts require a slightly different arrangement of data. In the next section,
you’ll get a quick introduction to all these possibilities, using just the simple column
chart and line chart.
Search JabSto ::




Custom Search