Forum Discussion
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...
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.
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
Solution Sage
Solution SageT0PH3Y Provide some data in tabular format. Will try and get back.
Thanks. Here you go
Date 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 01/04/2022 2247 1647 1066 967 933 906 952 1015 1153 1310 1662 2065 04/04/2022 2194 1528 761 711 634 621 634 673 770 898 1350 1796 05/04/2022 2146 1419 666 535 502 462 488 538 627 879 1277 1765 06/04/2022 2163 1082 633 585 555 537 564 648 760 1049 1577 1817 07/04/2022 2176 1493 816 701 654 637 633 682 792 1080 1398 1882 08/04/2022 2257 1569 1009 916 894 873 886 983 1110 1380 1614 1860 11/04/2022 2233 1405 919 831 808 779 786 812 877 1089 1358 1877 12/04/2022 2158 1365 842 737 709 670 678 712 778 1017 1388 1773 13/04/2022 2168 1617 894 813 781 751 763 806 883 970 1329 1808 14/04/2022 2149 1567 1053 954 932 902 904 970 1028 1179 1579 1911 19/04/2022 2164 1446 900 834 810 779 778 840 908 1027 1476 1821 20/04/2022 2136 1516 894 786 766 741 757 794 884 1047 1390 1715 21/04/2022 2096 1358 916 817 777 764 772 825 884 1047 1458 1847 22/04/2022 2116 1599 1099 1036 1006 994 1012 1087 1158 1383 1703 1974 25/04/2022 2111 1342 785 641 600 578 588 637 848 1056 1389 1868 26/04/2022 2119 1251 575 486 449 419 431 496 606 1040 1582 1799 27/04/2022 2130 1179 656 568 545 508 521 559 660 957 1382 1748 28/04/2022 2112 1433 753 664 634 616 621 668 743 1218 1575 1829 29/04/2022 2219 1537 992 897 869 844 903 932 1052 1355 1638 1977 03/05/2022 1829 1213 586 497 471 451 477 494 584 758 1101 1658 04/05/2022 436 1121 787 562 527 511 533 610 683 862 1360 1746 05/05/2022 2099 1372 687 551 524 490 514 551 665 890 1497 1795 06/05/2022 2088 1340 859 759 735 718 754 828 929 1137 1488 1858 09/05/2022 2123 1301 640 548 518 489 496 540 645 1016 1202 1820 10/05/2022 2095 1338 571 439 417 390 433 461 580 921 1166 1816 11/05/2022 2079 1426 581 571 550 512 525 598 687 880 1294 1818 12/05/2022 2172 1320 732 585 550 524 514 560 676 805 1284 1812 13/05/2022 2215 1335 997 860 828 806 822 919 986 1301 1514 1958 17/05/2022 2136 1373 571 511 464 440 461 520 609 768 1239 1829 18/05/2022 2141 1220 751 603 581 558 576 657 758 986 1455 1868 19/05/2022 2118 1346 749 606 585 555 582 646 752 1036 1367 1819 20/05/2022 2194 1388 1081 838 809 779 811 811 991 1134 1538 1925 23/05/2022 2153 1343 836 652 624 599 616 634 762 1076 1536 1832 24/05/2022 2177 1406 732 533 464 441 442 501 608 784 1300 1767 25/05/2022 2164 1274 790 640 605 578 589 634 753 946 1481 1843 26/05/2022 2146 1539 818 665 642 603 615 668 868 976 1351 1807 27/05/2022 2151 1645 1036 979 955 934 959 1021 1111 1325 1591 1930 30/05/2022 2205 1538 988 888 863 834 817 850 939 1073 1454 1846 31/05/2022 2167 1444 890 786 755 730 753 784 869 1135 1433 1759 01/06/2022 2205 1540 1024 927 910 885 906 962 1042 1203 1571 1939 06/06/2022 1962 1351 767 703 687 670 676 697 776 940 1217 07/06/2022 2178 1423 743 587 520 509 524 594 727 921 1304 1809 08/06/2022 2185 1475 751 580 552 525 539 604 668 873 1334 1766 09/06/2022 2147 1465 859 704 662 641 647 718 810 1111 1379 1843 10/06/2022 2234 1501 1053 958 920 908 933 991 1160 1252 1639 2007 13/06/2022 2208 1535 920 745 726 698 713 727 820 1000 1403 1883 14/06/2022 2164 1421 668 531 483 448 463 561 647 859 1304 1753 15/06/2022 2157 1482 771 616 588 565 580 634 718 905 1331 1825 16/06/2022 2200 1486 818 659 636 609 639 689 802 978 1460 17/06/2022 2255 1540 1087 966 947 924 938 998 1140 1266 1680 2013 20/06/2022 2120 1401 786 649 610 592 606 628 718 856 1125 1722 21/06/2022 2136 1387 697 548 531 504 486 577 692 886 1341 1773 22/06/2022 2210 1544 906 695 667 645 691 712 817 1026 1449 1870 23/06/2022 2195 1577 971 814 787 758 762 805 916 1207 1475 1895 24/06/2022 2258 1700 1138 1023 992 975 988 1041 1154 1300 1596 2000 27/06/2022 2223 1535 983 818 787 754 745 778 881 1012 1444 1874 28/06/2022 2167 1496 853 718 675 639 652 709 769 937 1322 1834 29/06/2022 2220 1568 895 767 734 690 695 741 927 1013 1417 1839 30/06/2022 2190 1544 917 801 772 720 729 782 941 1158 1504 - ChiragGarg2512
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.
Perfect. Thank you.
I had already changed in power query but not in Table View.