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.
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.
Retrieving data ...