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?

Hi Eric, 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. Best, 365 Eli

Follow this topic

Eric Layer

Last answered:

20 Oct 2021

Posted on:

17 Jul 2021

Making duel axis chart with selected dates

in The Complete Data Visualization Course with Python, R, Tableau, and Excel / What does the Course Cover

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

20 Oct 2021

Making duel axis chart with selected dates

Submit an answer

related questions