New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Pivot Chart created from PowerPivot not sorting correctly

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Pivot Chart created from PowerPivot not sorting correctly

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

Hello,
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?

Thanks
  • 0

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

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 65 guests