Unable to get create line chart based on Start and End Date

[siddiq ali]

Hello All,

I rarely work on Excel and I feel I am infant on it.

* I had created the line chart based on start and end date,  You can see below I need to get the        line in chart based based on 1st row Start Date(9/22/2020) and End Date(9/25/2020) .
* But the lines are getting created based on 1st row Column of Start Date(9/22/2020) and 2nd row          column of Start Date(10/1/2020)

can any one please help me how can I make the things happen

[#2 · Accepted solution]

@siddiq ali 

Click anywhere on the chart to select it.

Activate the Design tab of the ribbon (under Chart Tools).

Click 'Switch Row/Column' in the Data group.