0 Replies Latest reply on Apr 24, 2017 12:30 PM by Kishor c

    How to create side by side bar and line chart

    Kishor  c

      Hi ,

       

      Here i attached a workbook for your reference , I am trying to create a side by side bar chart and line in combination. Attached required viz. Please help.

       

      About data:

      Every day i have some values repeating in x axis (Strike), so some of them doesn't have values.

      if the value present in two consecutive days i want to SUM(Open Int) for each strike as bars ,  bars can't be stacked as shown in the Sheet 1. Bars are side by side (grouped)

      also other measure in line on top of the bar.

       

       

      Thanks,

      Kishor