• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Plotting two candlestick charts; primary and secondary axis

On the IBM and the .IBM241004C225 charts, sometimes I can select each of the data series and get the option to plot a secondary axis. I'm not sure what I'm doing to select it the right way.

Anyway, starting on row 52, in the chart "IBM and .IBM241004C225" I'm trying to plot IBM and .IBM241004C225 as candlestick charts, but I can't change .IBM241004C225 to plot on a secondary axis. I can't get the data series selected the right way.

Is it possible to plot two candlestick charts on one graph and use a primary and secondary axis?

Also, why doesn't the .IBM241004C225 chart look like the attached candlestick chart? The attached chart is from 9/30 to 10/04, showing all 11 candlesticks.
 

Attachments

  • IBM 4 OCT 24 225 CALL.xlsx
    25.3 KB · Views: 1
  • IBM 225 CALL chart.png
    IBM 225 CALL chart.png
    5 KB · Views: 4
Last edited:

DashboardNovice

You should able to move other part of chart to the secondary axes
and
after that add there needed Chart Elements.
Something like that..
 

Attachments

  • IBM 4 OCT 24 225 CALL.xlsx
    26.6 KB · Views: 3
Back
Top