Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and...

Explanation

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!

To create a dual axis chart for the problem mentioned:

1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is: