New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.


Pivot Chart created from PowerPivot not sorting correctly

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

Pivot Chart created from PowerPivot not sorting correctly

Postby lxd » Fri Mar 17, 2017 3:34 pm

I have the results from a PowerPivot model for which I need to chart. Very simple. I want to sort by month - Jan, Feb, Mar, Apr, etc....I show the month in numeric format as well as alpha in my PowerPivot results, so I sort by numeric month. Within PowerPivot, I click on create pivot chart. When I look at my chart in Excel, I lose the sort, so the chart sorts in alpha. I fix this by bringing the numeric month on the chart, but then I don't want to display the number. How can I either hide the number on my pivot chart, or be able to create the chart so I don't have to display the numeric month but still sort by month?

  • 0

Posts: 1
Joined: Mar 17, 2017
Reputation: 0
Excel Version: 13

Return to General Excel Questions

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 8 guests