In This Chapter
• Creating a chart from spreadsheet data
• Formatting a chart for clarity
• Printing a chart
• Making changes to a chart
I know it sounds tired, but a picture really is worth a thousand words, especially if your “words” are really numbers you’re trying to explain. Suppose that you have a year’s worth of sales figures for three different products your company produces, and you want to compare the sales of the products over the year. If you try to make the comparison using raw data, you’ll probably get a headache. But, if you chart those same numbers, you can easily understand what’s happening.
In this chapter, I’ll show you how to use the data in a Quattro Pro spreadsheet to quickly and easily create a variety of charts. Then, we’ll spruce up those charts to make them truly meaningful and easy to read, and I’ll show you how to print charts. Last, we’ll explore what you need to do when you need to change an existing chart.
The type of chart you create affects the reader’s understanding of the information you want to present. For example, consider the data in Figure 11.1.
Figure 11.1. Using this data, you can produce several different types of charts, each with a different meaning to the reader.
I can best compare sales by region for each product if I produce a bar chart like the one shown in Figure 11.2.
Figure 11.2. A bar chart helps compare two or more values for the same set of data; in this figure, the chart compares sales for three regions and three products.
Selecting the correct data to appear in the chart goes hand in hand with selecting an appropriate chart type. Selecting the wrong data can produce a very strange chart. For example, in Figure 11.2, I charted A3.D6. Quattro Pro uses the text information in the selection to automatically label data on the chart.
If, instead, I include the total row (row 7) and the total column (column E), I get the odd-looking chart shown in Figure 11.3, which doesn’t really make much sense, if you think about it.
Figure 11.3. If you include totals when creating the chart, it appears as if you’re trying to compare a fourth product.
If I change the goal of my chart, I also need to change the type of chart I produce and, possibly, the data to chart. For example, a pie chart is more appropriate when you want to compare portions of anything to the whole enchilada.
I added labels and a legend to the pie chart after I created it, using techniques described later in this chapter in the section, “Formatting a Chart.”
Using the same data shown in Figure 11.3, I can produce a pie chart that shows each region’s portion of total sales, or I can produce a pie chart that shows each product’s portion of total sales. The pie chart I produce will depend on the data I select.
In Figure 11.4, I created a pie chart that shows sales by region. To create the chart, I selected B7.D7—the cells that contain total sales for each region.
Figure 11.4. To create this pie chart, I selected the totals for each region.
In Figure 11.5, I created a pie chart that shows the sales by product. To create the chart, I selected E4.E6—the cells that contain the total sales for each product.
Figure 11.5. To create this pie chart, I selected the totals for each product.
Quattro Pro contains a wide variety of chart types from which you can select; make sure that you select a chart type that is appropriate for the information you want to convey.
You can create a chart in one of two ways in Quattro Pro:
• You can use the Chart Expert, a wizard that walks you through the process.
• You can draw the chart and then modify it as needed.
Creating a chart using the Chart Expert wizard is easy; follow these steps to create a chart and place it in a separate chart window:
I include the cells containing labels in the selection so that Quattro Pro automatically labels information in the chart.
Figure 11.6. In the Chart Expert, you start by selecting the data that you want to chart.
Figure 11.7. Select the cells containing the data you want to chart.
If you compare Figure 11.8 with Figure 11.6, you’ll notice that the sample chart in the Expert dialog box makes more sense after you select the correct data than it did when the Chart Expert first opened.
Figure 11.8. After you select the correct range, the sample in the Expert dialog box makes more sense.
Figure 11.9. Select a chart type.
All the charts displayed in this chapter up to this point have appeared on the spreadsheet with the data.
Figure 11.10. Use these boxes to describe the information on the chart.
If you’re unsure of the type of chart to produce, click the Advisor’s Choice button, and Quattro Pro will suggest a chart type. Remember, though, that it may not be appropriate for what you want to show.
Figure 11.11. You can select a color scheme for a chart.
Click the chart window’s close button to redisplay the spreadsheet.
If you opt to place a chart in the current sheet in step 6 above, Quattro Pro lets you draw the boundaries of the chart in the spreadsheet. You also can insert a chart without using the Chart Expert by drawing the chart. When you draw a chart, Quattro Pro makes its best guess for the chart type, and you then use formatting options described later in this chapter to add other information to the chart.
To draw a chart, follow these steps:
Figure 11.15. Quattro Pro inserts a chart like this one when you draw a chart.
Suppose that you want to change the chart type for an existing chart. No problem; follow these steps:
Figure 11.16. Right-click a blank area of a chart to display a menu.
Figure 11.17. Use the Chart Type Gallery to change the chart type after creating a chart.
If Quattro Pro displays placeholders for a title and subtitle, you can double-click the placeholder, remove the placeholder word—”Title” or “Subtitle,” and so on—type the text you want, and press Enter on the keyboard.
If you want to add titles to a chart, follow steps 1–4 above, selecting Titles instead of Gallery from the menu in step 3. If you want to add a legend to a chart, follow the steps 1–4, selecting Source Data instead of Gallery from the menu in step 3.
If you place a chart in a spreadsheet, you print the chart when you print the spreadsheet, using the same techniques described in Chapter 6, “Printing.” If you place a chart in its own window, you must print that window. To find a chart that you placed in its own window, click the Objects Sheet button at the bottom of the Quattro Pro window (see Figure 11.18). Quattro Pro displays a sheet that contains all the charts you created in a notebook.
Figure 11.18. The Objects sheet displays icons that represent all the charts you created in a notebook.
Double-click the icon that represents the chart you want to view. Quattro Pro displays the chart represented by the icon you selected.
If you double-click the wrong icon, just redisplay the Objects sheet and try again.
When you find a chart created in its own window, click the Print button to print it. When you finish with the chart, click the chart window’s Close button—that’s the bottom X in the upper-right corner; if you click the top X, you’ll close Quattro Pro. When you close the chart window, Quattro Pro redisplays the Objects sheet. To return to the spreadsheet at the front of the notebook quickly, click the Objects sheet button at the bottom of the Quattro Pro window again.
Suppose that the data in your chart changes; you know, some department missed some sales and adjusted the numbers after you create your chart. You don’t need to re-create the chart. Instead, just change the numbers in the data area of the spreadsheet. Quattro Pro automatically updates the chart to reflect the change.
3.133.159.223