to show 2 values in a single bar chart

[asmi]

How to show 2 values in a single bar chart in excel 2013. Want to show maximum and minimum temperature of a day in a single bar chart.

thanks

[MrShorty]

Are you thinking of something like this floating column or bar chart: http://peltiertech.com/Excel/Charts/...ngColumns.html

[Jon_Peltier]

Alternatively, you could plot a line chart with daily min and max temperatures. Using the plus icon next the the chart in Excel 2013 or the Chart Tools > Layout tab in Excel 2007-2010, add up-down bars, which connect the first and last line chart data in the chart with a vertical bar. Then format the plotted series so they use no markers and no lines.

FloatingUpDownBars.png