|
![]() |
![]() |
Creating a chart Pictures often tell more than words. To enhance our accounting spreadsheet we will introduce some charts. To do that we, select the range on the worksheet that we want to chart (highlight all the data you want chart to cover, using mouse) If the range includes labels at the left and the top, then these labels will be used as the X and Y axis labels on the chart. Then click the Chart Icon on the Workbook Toolbar (or use select Tools->Charts from the menu). The Chart Selection Panel will appear, see picture below. In our example we have opened Japan worksheet and have selected (by highlighting) cells A8:B9 cells. There are three main Chart Types (Bar, Line and Area). Within each Type there are several variations: for example a Bar Chart can be Stacked, Horizontal, 3D and more. Click on the Type you want. The Chart will draw itself on the worksheet at the current cursor position see our Japan - Budget pie chart below. The Chart Inspector will also appear. Use the Chart Inspector to change and customize the chart. You can have as many charts as you like on the worksheet You can move and resize charts. See also:
|
||
|
||