Forum Discussion

siddiq ali's avatar
siddiq ali
Copper Contributor
Sep 30, 2020

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

 

  • 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.

     

  • 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.

     

Resources