troubleshooting Question

Charts help

Avatar of Isaac
IsaacFlag for United States of America asked on
JavaScriptMicrosoft SharePointjQuery
2 Comments1 Solution375 ViewsLast Modified:
Hi All,

I am sort of at a dead end and not sure how to proceed.  Hope I can get some help/insight on how to go forward.

I created chart using google api in SharePoint 2007.  It looks somewhat like this

Here's a picture of it in SharePoint

Here's my problem, as you can see, the x-axis uses months but the client has changed it to actual dates in the fiscal year.  So, it should be like this

These dates are in a list with associated data to plot. These dates represent all dates, separated by a week, in a fiscal year starting with October 4, 2012.

Previously I created a multidimensional array that would allow me to plot my lines graphs by month.

 I was then able to pick which index to manipulate like so dataValues[monthProjectedIndex][10] += parseInt(checkForUndefined($(this).attr("ows_Plan")));

The dates make it somewhat difficult because there are 52/53 weeks in a fiscal year and I don't want to manually create an array with all the date values.

Any ideas?  Code attached.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros