SOLVED
Home

Excel PivotChart x-axis label cannot be change or set

%3CLINGO-SUB%20id%3D%22lingo-sub-875689%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20PivotChart%20x-axis%20label%20cannot%20be%20change%20or%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414809%22%20target%3D%22_blank%22%3E%40Alex_Phang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20scale%20datetime%20axis%20as%20desired%20using%20scatter%20chart.%20However%2C%20scatter%20chart%20is%20not%20possible%20to%20build%20directly%20on%20Pivot%20Table%20-%20some%20workarounds%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F812337%2Fcant-create-a-scatter-chart-from-a-pivot-table-in-excel%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F812337%2Fcant-create-a-scatter-chart-from-a-pivot-table-in-excel%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873964%22%20slang%3D%22en-US%22%3EExcel%20PivotChart%20x-axis%20label%20cannot%20be%20change%20or%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%223%22%3ECurrently%20I'm%20using%20Microsoft%20Excel%202019%20to%20do%20this%20PivotChart.%20I%20cannot%20set%20or%20change%20the%20x-axis%20label%20on%20the%20PivotChart.%20%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-873964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%202019%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivotChart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Alex_Phang
Occasional Visitor

Currently I'm using Microsoft Excel 2019 to do this PivotChart. I cannot set or change the x-axis label on the PivotChart.

1 Reply
Solution

@Alex_Phang 

You 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies