SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1729226%22%20slang%3D%22en-US%22%3EUnable%20to%20get%20create%20line%20chart%20based%20on%20Start%20and%20End%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1729226%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EI%20rarely%20work%20on%20Excel%20and%20I%20feel%20I%20am%20infant%20on%20it.%3CBR%20%2F%3E%3CBR%20%2F%3E*%20I%20had%20created%20the%20line%20chart%20based%20on%20start%20and%20end%20date%2C%26nbsp%3B%20You%20can%20see%20below%20I%20need%20to%20get%20the%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20line%20in%20chart%20based%20based%20on%201st%20row%20Start%20Date(9%2F22%2F2020)%20and%20End%20Date(9%2F25%2F2020)%20.%3CBR%20%2F%3E*%20But%20the%20lines%20are%20getting%20created%20based%20on%201st%20row%20Column%20of%20Start%20Date(9%2F22%2F2020)%20and%202nd%20row%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20column%20of%20Start%20Date(10%2F1%2F2020)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Ecan%20any%20one%20please%20help%20me%20how%20can%20I%20make%20the%20things%20happen%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223054iDE64A697D75325EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22excel.PNG%22%20alt%3D%22excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1729226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1729481%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20get%20create%20line%20chart%20based%20on%20Start%20and%20End%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1729481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61151%22%20target%3D%22_blank%22%3E%40siddiq%20ali%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20anywhere%20on%20the%20chart%20to%20select%20it.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Design%20tab%20of%20the%20ribbon%20(under%20Chart%20Tools).%3C%2FP%3E%0A%3CP%3EClick%20'Switch%20Row%2FColumn'%20in%20the%20Data%20group.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3550.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223066i7FDE255E11D55281%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3550.png%22%20alt%3D%22S3550.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

excel.PNG

 

1 Reply
Highlighted
Best Response confirmed by siddiq ali (Occasional Contributor)
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.

 

S3550.png