Up/Down Bars

[Ampleman]

I am attempting to create a graph that displays minimum, maximum and mean prices for various products, as well as outlier prices. Whenever I add the outlier price the graph wants to include it as part of the original group (minimum, maximum, mean). For example assume the minimum is 50, max is 60 with a mean of 55. I would like to display these using the up/down bar function. Next I want to add an outlier such as 40, however the up/down function sees this as the new minimum. Any help, either within excel or with add-on software would be appreciated.

 

[VoG]

This may help you http://peltiertech.com/Excel/Charts/StockChartPlus.html

 

[Ampleman]

Thank you for the help, however I am still experiencing problems. I am running Excel 2007. I followed the Peltier instructions which worked until I got to "Format the New Series". Essentially this tells me to select the new series and change the Chart Type to an XY Scatter. Apparently this cannot be accomplished as I received the following error message: "Some chart types cannot be combined with other chart types. Select a different chart type". I tried other chart types, but to no avail; I still get the same message. What next?

Thanks

 

[Jon Peltier]

You could move the outlier series to the secondary axis. Alternatively you could follow the updates 2007 instructions, mandated because Microsoft broke some of the stock chart's functionality in 2007. See Stock Charts in Excel 2007 for the details.

 

[Ampleman]

Hello Jon,

Thank you for the reply, which was very helpful. For this data set I chose option 1: Secondary axis, however in the future I may need to employ the more involved solution.

Gerry