Sep 25 2019 01:35 AM - edited Sep 25 2019 06:36 PM
Currently I'm using Microsoft Excel 2019 to do this PivotChart. I cannot set or change the x-axis label on the PivotChart.
Sep 25 2019 02:24 PM
SolutionYou may scale datetime axis as desired using scatter chart. However, scatter chart is not possible to build directly on Pivot Table - some workarounds are here https://superuser.com/questions/812337/cant-create-a-scatter-chart-from-a-pivot-table-in-excel
Sep 25 2019 02:24 PM
SolutionYou may scale datetime axis as desired using scatter chart. However, scatter chart is not possible to build directly on Pivot Table - some workarounds are here https://superuser.com/questions/812337/cant-create-a-scatter-chart-from-a-pivot-table-in-excel