Continue With API Project - Data Analysis With Charts

I forgot to attach the Workbook on the previous post, it is attached to this one.

This will get you the data, I'll leave the charting to you:

Please Login or Register  to view this content.

Some thoughts about the code I posted. There is no guarantee that the dates will line up, for thoroughness, you should check each date value pair and insert them into the array rather than assuming that the same time stamp in each array will have the same index. I have assumed that this is the case as I know what graphing library they are using and what the input requirements are - should the API or graphing library change expect this to fail. Furthermore, it could fail in a horrible way where you get the wrong data for the wrong day and never notice the error.

As such, properly code to allow for this - this is a proof of concept to get you started, you have been warned

Hey Kyle, Thank you for your help! I do not know anything about VBA or what to do with it. That being said, the code you posted looks awesome, but i have no idea what to do with it...? if you could throw it in the copy of the Workbook I posted and attach it so I can see how it is working, that would be amazing, if you are not interested, i understand and still appreciate your help immensely. I am not sure where this data is going to show up on my Workbook (attached). Is this producing line charts? and searchable by time periods?

It puts the underlying data that you need for your graph in Sheet2. You can put it in a module and run the sub, just copy and paste it underneath the GetJSON sub.

You are starting learning VBA with some pretty hard stuff. If you want to learn VBA may I suggest you start with something easier. If you aren't bothered about learning VBA and just want to get your workbook up and running, may I suggest the commercial services forum - it's probably better placed to get what you want. If you're happy to wait and get what help people will offer you for free then great, but please amend your title and remove "(HELP)" it's against the forum rules.

Ok, will do.... Thanks again for all of your help!!