Date Formatting


Author
Message
Greg Corliss
Greg Corliss
Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)
Group: Forum Members
Posts: 9, Visits: 17
I have created a stacked bar chart from a SharePoint List View.
My dates show up as 1/1/1900 12:00 AM. I just want the month to show as JAN.
I've gone into Chart Areas > Axes > Primary X > Scale and set the sub Type to Date Time and Formatting to Fixed and set the Label format to MMM and nothing changes.
I've also tried setting the Label Angle and step mode set to a custom one month step to no avail.
Below is how I have it set up:

https://www.nevron.com/forum/uploads/images/bddbc18e-29e4-4908-9f4c-f518.jpg


Reply
Greg Corliss
Greg Corliss
Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)
Group: Forum Members
Posts: 9, Visits: 17
I figured it out. Reading through the documentation for numerical Formatting. All I had to do was put a P (without any quotes) in The Label format and it converted it to a percentage.

Thanks for all the help.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search