Tuesday, April 12, 2011

How to Create a Floating Bar Chart in Microsoft Excel 2003


1. Set up your spreadsheet data with at least two rows of data. One of the rows of data will be what you actually want to show in the graph, and the other data set needs to have values that are less than the data set you want to show.
2. Highlight the data set. Click on the 'Insert' menu at the top of the screen, and then click on 'Chart' to bring up the chart options.
3. Click on the 'Bar' option from the list of chart type options on the left-hand side to bring up all of the bar chart options. Click on the 'Stacked Bar Chart' option, click 'Next' twice, and then click 'Finish' to build chart in the spreadsheeet.
4. Click on the lower series of data in the chart to select it. Right-click, and click on the 'Format Series' command to bring up the Series options window.
5. Click on the 'Patterns' tab. Select 'None' under Border and Area, and Click 'OK.' The upper series should be the only part showing on your graph, and it should be 'floating' above the axis.

Blogger news