I’m having some trouble aligning the data on the line and bar chart with the same x-axis. I want the data on both the line and bar chart to be plotted as is without the values being sorted from largest to smallest. The data on the bar chart is plotted as is based on the x-axis range values, however the data on the line chart is being plotted randomly and doesn’t align with the bars that are plotted on a given ranges.
E.g. Given the below sample dataset, I want the value 1 for both line and bar column to be plot on 2001, so that the two values for the same x-axis point overlap each other on the chart.
However, the chart plots value 1 for bar on 2001 and then plots value 3 for the line on top of the bar, instead of actually plotting value 1 for the line as well.
Thanks in advance for your help