Categories in Reverse Order

Question

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?

Answer 1

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.