Making duel axis chart with selected dates
When selecting the 3 rows to make the duel axis chart as in the video (net sales, % gross profit, and selected dates) even though I select all 3 rows in the same order as the video excel is neglecting to display the dates along the x-axis and instead either displays number 1 through 12 or completely misinterprets the data when attempting to insert a graph. Is there a better way I can select data to then utilize when creating a graph?
sorry to hear you're having difficulties with the charts.
If you try and shift the columns from vertical to horizontal, you might be able to avoid this issue. The problem is that Excel doesn't always automatically recognize the time series data. Let me know if you have any further issues.