Share via

Categories in Reverse Order

Anonymous
2013-09-30T20:17:47+00:00

I have a pivot chart with date as the x-axis, 2 series on a primary and 1 series on a secondary axis.  My pivot table is sorted in descending order by date because I need the most recent date on top.  To chart the data so the date is left to right, I've turned on Categories in Reverse Order.  

  1. When hovering over the data points on the primary series, the date is reversed. Example x-axis is Jan1-Jan31. When hovering over the very right data point the date says Jan 1, but the data is actually Jan 31.
  2. The Secondary Axis is plotting Jan31-Jan1 instead of the Reverse Order.

Is this a problem with Excel or is there other options that I can try to correct all this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2013-10-01T14:43:15+00:00

    Hello,

    For issues related to pivot chart, your query would be better addressed in the Office Excel IT Pro forum link below:

    http://social.technet.microsoft.com/Forums/en-US/excel/threads

    For any other Office related queries, you may always post here and we are happy to assist.

    Thank you.

    Was this answer helpful?

    0 comments No comments