Creating candle stick images to look like this image

**hendrikbez** · 10-10-2021, 01:38 PM

I am making a chart for currency with candle ticks, but is it possible to do it like this image. If so how?

Excel 2016

**MrShorty** · 10-11-2021, 10:58 AM

I don't know how exactly you need to match the picture, but it should be possible to create something similar.

The stock charts in my older version of Excel do not seem to support 3D effects like this, so it may not be possible using the built in specialty charts. If you do not find 3D options in your chart type and formatting options using one of the built in specialty chart, then you can create the same chart using a basic stacked column chart that will support various 3D effects. If you are unfamiliar with creating candlestick/box charts as stacked column charts, you might start with a tutorial like this: https://peltiertech.com/excel-box-an...ams-box-plots/

Follow the tutorial (using a 3D stacked column chart) to see how it all comes together and to make sure you can find all of the necessary formatting dialogs. Then try it with your own data. Let us know where you run into trouble.