Excel: Creating a Chart/Graph of one column of data

Open an EXCEL document. Select the data that you will be using for the chart/graph (do not include any headings) (see figure 1). From the menu bar, go to Insert - Chart. Under Chart type, choose the kind of chart/graph you want. Under Chart sub-type, choose that kind of chart/graph. Click the blue NEXT button. At the top of this window, click the Series tab to place the labels for the data in the chart/graph. Click the up arrow next to the blank field for Category Labels. The window will become narrow (see figure 2). Select the data for the labels of the Excel chart/graph (see figure 3). Click again on the down arrow of the Chart Source Data window to expand it. Click the blue NEXT button. type a name for the chart/graph in the Chart title box. Click the blue NEXT button. Choose whether to place the graph on its own page (click the button next to As new sheet) or as part of the page with the graph data (click the button next to As object in). Click the blue FINISH button. The chart/graph should appear in your document. To move the chart/graph, click in the white area of the chart/graph and drag it. To change a color of an item (bar, slice, etc.) in the graph, click once on the item to select it, and then double click to open the Format Data window. Click on the Colors and Lines tab. If all of the data is the same color and you want to vary the colors, click on the Options tab and check the box next to Vary colors by slice (point). If your table has more than one column of data, you will need to enter the values for the series after step 8 above. Click on an item in the Series window (see figure 4) and then type its label name in the Name window. In this example, the series names are the names of the values of the bars.

figure 1   figure 2 figure 3 figure 4