I have 2 worksheets in excel with 4 columns each. The data in both worksheets is identical. eg., One worksheet has mock up data, the other worksheet has actual data. I need to create a column clustered graph with the two data. We will also need a trend line to show how the data varies over time.
The graph should be a plot between Month and Amount. Two dropdowns - Calendar year, Product