Forum Discussion
siddiq ali
Sep 30, 2020Copper Contributor
Unable to get create line chart based on Start and End Date
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
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.
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.