To create any chart in Microsoft Excel, you must begin by selecting the data that you want to plot including any headings. You then have the choice of creating either a stand-alone chart or an embedded chart. To create a stand-alone chart, right-click on one of your worksheet tabs and choose Insert. Next, click on the chart icon and click OK. Excel creates a chart using the default chart type.
Having just created a chart, Excel will display three contextual tabs headed “Chart Tools”. The contextual tabs consist of Design, Layout and Format. The Design contextual tab enables you to change the chart type and the basic information about the chart such as the underlying data.
The Layout tab offers you a more intricate level of control over the various elements within your chart. For example, by default, Excel adds a legend to each new chart. If a chart has only one series of data, we don’t need a legend to tell us what the chart colours mean. We can therefore click on the Legend drop-down menu and choose None.
The Format contextual tab gives us the most primitive control over your chart elements. It is here that we are able to click on individual items and change them at the object level. In other words, we are working on these elements purely as drawing objects rather than as elements of a chart. However, even at this primitive level, Excel still indicates the relationship between the chart elements and the underlying data. Thus, for example, when an individual data point is highlighted, Excel displays the corresponding worksheet address in the formula bar.
When creating a standalone chart, you are not given the option of choosing the chart type during the chart creation process. If you want to change the chart type, you have to do so at a later stage by choosing a Chart Type option in the Design contextual menu.
As for the chart sheet which contains the chart, it behaves in much the same way as a worksheet. It can be renamed or deleted by right-clicking the sheet tab and choosing Rename or Delete from the context menu.
If you have any more concerns please comment for email me. Thanks for reading this.
No comments:
Post a Comment