How to create a candlestick chart from a Pivot table?

[Tom_H]

Is it possible to create candlestick chart from a PivotTable?
I just can't find out how to arrange the data to be able to create a candlestick chart.
I only get "You can't create this chart type inside a PivotTable".
I have the PivotTable connected to a database connection and it would be really nice to get it to work.
But I guess it is not possible, I need to create a table in excel first and the pivot the table for the candlestick chart.
Line charts works, no need to download to a Excel table first.
See picture.

 

[awoohaw]

Are Candlestick Charts the same as Box & Whisker Charts? Or are they the similar but with a whisker at one end only?
To do that I'd make the "hidden" whisker end equal to the extreme value of the box on the end that you do not want the whisker.

 

[AhoyNC]

Maybe the attached link showing a work around will help.