goss
Active Member
- Joined
- Feb 2, 2004
- Messages
- 372
Hi All,
Using Excel 2016.
My Pivot Table has Row Field of Dates As Text in the Format 01/04/2017 etc...
I created a Combo Pivot Chart with Area and Line. So far so good.
Now I am trying to figure out how I can display X-Axis so that only shows MM Char(10) YY
I tried a variety of option in the data source, but then consolidates the data in the Row Field.
I also tried leaving the date as a number, but the Pivot Table would not display the individual dates, just Year, Quarter. Month. Even after I removed Year and Quarter, it would only give me months - thus dates as text.
Any other ideas?
thx
w
Using Excel 2016.
My Pivot Table has Row Field of Dates As Text in the Format 01/04/2017 etc...
I created a Combo Pivot Chart with Area and Line. So far so good.
Now I am trying to figure out how I can display X-Axis so that only shows MM Char(10) YY
I tried a variety of option in the data source, but then consolidates the data in the Row Field.
I also tried leaving the date as a number, but the Pivot Table would not display the individual dates, just Year, Quarter. Month. Even after I removed Year and Quarter, it would only give me months - thus dates as text.
Any other ideas?
thx
w