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.

     

     

T0PH3Y's avatar
T0PH3Y
New Member
2 years ago

ChiragGarg2512 Thanks. Please could you clarify what you meant, i've setup a Pivot Table but not sure how this changes anything 

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

    In power Query, select the date column and unpivot[not pivot] other columns. This will create a table with second column being the time column and a table where for a date every time is available. Now when time vs values[The third column] is plotted it will not be the desired result but when the date column is added as legend it should give the desired result for every date available in the date column.

    • T0PH3Y's avatar
      T0PH3Y
      New Member
      2 years ago

      Thank you. I now have the data unpivoted.

       

       

      However all the data is positioned at the bottom of my graph and not visible. And also the time doesnt show as the Y Axis

       

       

       

       

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