The questions that you will be shown in the next windows. Use Excel's chart assistant by pressing the button. The Insert menu, select the Chart option. But, Excel will be confused if the description that you need for the X axis are numbers. The content of the first column from the range of cells will be used as the description for the legend of the chart. Generally, the first row or row selected from the range of cells will be used by the chart for the description Don't take single cells scattered everywhere on your worksheet. Make sure that every range of cells selected represents at least a data series for the chart. Use the instructions in the Basic operations page to select only the blocks of cells that you need. They will be added to the chart and leave empty spots in your chart. The data by using a block (continuous or non-continuous), for the exercise, The following data in the appropriate cells. This exercise consists in creating a "3D Column chart" on a new worksheet. Quickly analyze the trends in data series.Īnalyze proportions among different data series. Change the size, color and orientation of text.
0 Comments
Leave a Reply. |