Chart Types
When you create a chart in Excel, you have many types of charts from which to choose. If you wanted to change an existing chart’s type, you would click on the Chart Type would then be displayed, providing buttons for 18 different chart types. E.g. Pie, Bar, Area, Column, Line, Radar, XY (Scatter), Bubble, 3-D Area, 3-D Line etc.
The type of chart you use depends on the type of data that you are charting. Select the Chart sheet. Click on the Chart Type drop-down arrow. Click on the Bar Char button.
In addition to using the Chart Type button to change the chart type, you can use the Chart Type dialog box to view chart sub-types, custom chart types, and user-defined chart types. To display the Chart Type dialog box, you select the embedded chart or display the chart sheet, and choose Chart, Chart Type. Choose Chart, Chart Type. Under Chart Type, select Area. Select the Custom Types tab. You can select from several built-in custom chart types, or you can create your own chart type. In the Chart Type list box, select B&W Area. Click on Cancel.
NB: besides the Char Type button, you can also use the menu to change the chart type by choosing Chart, Chart Type. Excel provides eighteen different types of charts.
Modifying Embedded Charts.
We’ll modify an Embedded Chart by changing its type and position. Select the Chart Data sheet. Select the embedded chart. Click on the Chart Type drop-down arrow. Select 3-D Pie Chart. The chart type changes to 3-D Pie, but the pie-slice labels remain intact. You can drag a pie slice out of the chart to “explode” it. This feature is helpful when you want to call attention to one slice of the chart.
You can print an embedded chart as part of the worksheet, or you can print it separately. When you print an embedded chart as part of the worksheet, the size, proportions and position of the chart on the printout correspond to how the embedded chart is sized and placed on the worksheet. To print an embedded char with the worksheet, you must first verify that the embedded chart is not selected. Then you choose File, Print to display the Print dialog box. Because the embedded chart was not selected prior to choosing File, Print, the Active Sheet(s) option is selected by default under Print What.
To print, you would just click on OK. If you want to print an embedded chart by itself, you select the embedded chart, and choose File, Print to display the Print dialog box. Because you selected the embedded chart first, the selection option under Print What is chosen by default. You can adjust the print settings before you send your print job to the printer by using print Preview command.
Procedure: choose File, Print, click on Preview. When you print an embedded chart with a worksheet, you must size and position it on the worksheet. The page Setup options enable you to control how the data and char print. The Print Preview window enables you to view and work with the setup of your printout before you actually print. Click on setup. The Page Setup dialog box is displayed. The printout is set for portrait orientation, at 100% of its normal size, on letter-sized paper. Select the margins tab. Under Center on Page, check Horizontally. Click on OK. Then click on Close.
click here to go to the previous lessen
Regards,
BEM T. CELESTINE
Social Plugin