Sep 30 2020 07:17 AM - edited Sep 30 2020 07:18 AM
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
Sep 30 2020 07:55 AM
SolutionClick 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.
Sep 30 2020 07:55 AM
SolutionClick 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.