Forum Discussion

T0PH3Y's avatar
T0PH3Y
New Member
2 years ago
Solved

Line Chart with Time on Y Axis

Hi,    I'm trying to create a line chart to analyse car parking usage between 7am and 6pm on the Y Axis. I then have data for the past 2 years that i want to plot against the those times, to replic...
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    T0PH3Y , 

     

     

     

    Check the data type of the time column and change it to just time. If this doesn't work change the type in power query.

     

     

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

T0PH3Y Provide some data in tabular format. Will try and get back.

T0PH3Y's avatar
T0PH3Y
New Member
2 years ago

Thanks. Here you go

 

Date07:0008:0009:0010:0011:0012:0013:0014:0015:0016:0017:0018:00
01/04/202222471647106696793390695210151153131016622065
04/04/20222194152876171163462163467377089813501796
05/04/20222146141966653550246248853862787912771765
06/04/202221631082633585555537564648760104915771817
07/04/202221761493816701654637633682792108013981882
08/04/20222257156910099168948738869831110138016141860
11/04/202222331405919831808779786812877108913581877
12/04/202221581365842737709670678712778101713881773
13/04/20222168161789481378175176380688397013291808
14/04/20222149156710539549329029049701028117915791911
19/04/202221641446900834810779778840908102714761821
20/04/202221361516894786766741757794884104713901715
21/04/202220961358916817777764772825884104714581847
22/04/202221161599109910361006994101210871158138317031974
25/04/202221111342785641600578588637848105613891868
26/04/202221191251575486449419431496606104015821799
27/04/20222130117965656854550852155966095713821748
28/04/202221121433753664634616621668743121815751829
29/04/2022221915379928978698449039321052135516381977
03/05/20221829121358649747145147749458475811011658
04/05/2022436112178756252751153361068386213601746
05/05/20222099137268755152449051455166589014971795
06/05/202220881340859759735718754828929113714881858
09/05/202221231301640548518489496540645101612021820
10/05/20222095133857143941739043346158092111661816
11/05/20222079142658157155051252559868788012941818
12/05/20222172132073258555052451456067680512841812
13/05/202222151335997860828806822919986130115141958
17/05/20222136137357151146444046152060976812391829
18/05/20222141122075160358155857665775898614551868
19/05/202221181346749606585555582646752103613671819
20/05/2022219413881081838809779811811991113415381925
23/05/202221531343836652624599616634762107615361832
24/05/20222177140673253346444144250160878413001767
25/05/20222164127479064060557858963475394614811843
26/05/20222146153981866564260361566886897613511807
27/05/202221511645103697995593495910211111132515911930
30/05/202222051538988888863834817850939107314541846
31/05/202221671444890786755730753784869113514331759
01/06/20222205154010249279108859069621042120315711939
06/06/2022196213517677036876706766977769401217 
07/06/20222178142374358752050952459472792113041809
08/06/20222185147575158055252553960466887313341766
09/06/202221471465859704662641647718810111113791843
10/06/20222234150110539589209089339911160125216392007
13/06/202222081535920745726698713727820100014031883
14/06/20222164142166853148344846356164785913041753
15/06/20222157148277161658856558063471890513311825
16/06/2022220014868186596366096396898029781460 
17/06/20222255154010879669479249389981140126616802013
20/06/20222120140178664961059260662871885611251722
21/06/20222136138769754853150448657769288613411773
22/06/202222101544906695667645691712817102614491870
23/06/202221951577971814787758762805916120714751895
24/06/2022225817001138102399297598810411154130015962000
27/06/202222231535983818787754745778881101214441874
28/06/20222167149685371867563965270976993713221834
29/06/202222201568895767734690695741927101314171839
30/06/20222190154491780177272072978294111581504 

 

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Icon for Solution Sage rankSolution Sage
    2 years ago

    T0PH3Y , 

     

     

     

    Check the data type of the time column and change it to just time. If this doesn't work change the type in power query.

     

     

    • T0PH3Y's avatar
      T0PH3Y
      New Member
      2 years ago

      Perfect. Thank you.

       

      I had already changed in power query but not in Table View.