Make sure your XY markers plot over your bar chart and you'll have a similar chart to what's shown. Your second bar data series is the range data and once you tweak your chart axis, will line up with the XY data markers. The range bars are a stacked bar chart, with the first data series (left most) being a hidden, dummy series to align all of your bars to a common low value. You're primary data points (the markers) will be the XY data, with the values on your X-axis and the Y-axis will be a basic integer series like 1,2,3 to match up with the bars you'll be adding for the ranges. If not, you'll need to be a little more creative.īasically you'll be overlaying 2 chart types: XY and stacked bar. If the high/low/range can be vertical, instead of horizontal, you can use Excel's built in Stock chart types and it'll take care of everything for you. This kind of chart is pretty easy to make in Excel, if you just think a little outside the box (and visit Jon Peltier's website:, you'll find all the tech info to make the chart at his site).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |