In a Gantt chart, horizontal floating bars along a horizontal date scale help program managers plan task start and end dates and durations, and track progress towards completion of these tasks.Floating bars can be useful to show running highs and lows in a data set, such as daily high and low temperatures, stock prices, diastolic and systolic blood pressure readings, etc.First of all, I’ll expand the data selection range to encompass Live Births and Deaths. I can now select the chart type and axis for each data series.Next, right-click the chart area and select Change chart type. I’m going to use line chart, and add the final two data series to the secondary axis, as per the below image: And the chart itself: Now that we’ve plotted our new data series, we’ll need a legend.This tutorial will show simple floating columns, stacked floating columns, floating columns that span the horizontal axis, and overlapping floating columns, all using stacked column charts.
As the name implies, the target audience are Excel beginners, but it’s also quite a comprehensive short guide from A to Z or better said, it takes you from ...
Step 5: Copy these calculations to columns C through G. Click “Error Bars” and select “More Error Bar Options” from the bottom of the menu. Select “Select Data” under the “Horizontal Axis Labels” section of the pop up box and click “Edit”. Right click the labels, select “Font” and change the font size to 8 (as in this example). Select “Format Axis” and under “Axis Options” change the “Maximum” to “Fixed” and change “Number” to 35.
Under the “Vertical Error Bars” section select the “Minus” direction, under the “Error Amount” section select “Custom” and click “Specify Value”. In the pop up box click the spreadsheet icon on the right hand side of the box and highlight cells B16 – G16 above. Change “Major Unit” to “Fixed” and change number to 5. Learn more about Box and Whisker plots by checking out my newsletter here.
Step 2: Calculate the data needed for construction of the box plots. C: Each box plot also has a box for the third quartile, which shows the difference between the third quartile and the median calculated in the “Calculation” table above. Highlight cells associated with Bottom, 2Q, 3Q (cells A27 through G29 in the example above) and click “Insert” tab above. Click the title and change text to “Average Number of Emergency Patients Arriving by Time of Day”.
Step 3: Copy these calculations to columns C through G. D: The down whisker is as long as the first quartile minus the minimum value E: The up whisker is as long as the maximum value minus the third quartile. In the “Charts” menu click “Column” and select “2D Stacked Column Chart”. Select the bottom series (blue boxes), click “Chart Tools” and click “Layout Tab”. Click the chart title, right click and select “Font”. To change the vertical axis scale, click the vertical axis and right click.