Type your data into any cells of an Excel spreadsheet. For example, type "Hours working" into cell A1 and type "9," which is the number of hours that an employee works each day, into cell B1.

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

Choose between chart-only and chart-and-analysis versions for either Excel 2003 or Excel 2007. Note that the Excel 2007 templates are compatible with Excel 2010.

Change the size and location of the bar graph accordingly. The graph created above is static in nature. If you wish to create a dynamic graph, you would have to use tables for the data. I hope it ...