Microsoft Excel is a spreadsheet program incorporated in the Microsoft Office suite that is used to collect and analyze data. One of the aspects of the data analysis is that this program can perform the automatic creation of graphs to see how various sets of data relate to each other. MS Excel has many standard graphs that can be selected depending on the relationships that you want to showcase. However, at times the program does not automatically give you the option to create a floating bar graph normally which is used to show a range of data in a graph with minimum values of above zero. But in case you are willing to add a couple of extra steps into the graph-making process, and then Excel will allow you to create the floating bar graph you need.
Microsoft excel is a spreadsheet application written and distributed by Microsoft Corp for Microsoft Windows and Mac OS X. its main features are calculations, graphing tools, pivot tables and a macro programming language known as Visual Basic for Application. The following are the simple steps that are needed to be followed to create a Floating Bar Chart in Microsoft Excel 2003.
The steps are as follows:
You need to set up your spreadsheet data with at least two rows of data. In one of the rows of data there will be what you actually want to show in the graph, and the other data will set needs to have values that are less than the data set you want to show.
You need to Highlight the data set and then click on the “Insert” menu at the top of the screen, and then again click on “Chart” to bring up the chart options.
On the left-hand side, under the list of chart types click on the “Bar” option to bring up all of the bar chart options. Now click on the “Stacked Bar Chart” option, click “Next” twice, and then again click “Finish” to build chart in the spreadsheet.
Now click on the lower series of data in the chart to select it. After the Right-click, click on the “Format Series” a command to bring up the Series options window.
Now just Click on the “Patterns” tab and then Select “None” under Border and Area, and Click “OK.” The upper series should be the only part that is showing on your graph, and it should be “floating” above the axis.
These above steps are easy to follow and in just few simple steps it will help you to create a Floating Bar Chart in Microsoft Excel. As Microsoft excel a part of Microsoft office is easy as well as user friendly to use and in no time a floating bar chart can be created.