Create Combo Chart With Secondary Axis. Select Combo Cluster Column - Line on Secondary Axis. Select range A1C13.
Then click Close button and you have successfully added a. In the Charts group click on the Insert Columns or Bar chart option. Select Design Change Chart Type.
Click anywhere in the chart you want to change to a combo chart to show the CHART TOOLS.
As a work around I added a Last N Days from NOW to my date table added a second column for Last N Days TXT using FORMATLast N DaysGeneral Number and set a visual filter on that to limit chart to last 21 days and the used the actual date on the axis. One measure shows Profit with a line mark and the other measure shows Sales with bar marks. In the combination chart click the line chart and right click or double click then choose Format Data Series from. Click DESIGN Change Chart Type.