Hi,
I was hoping someone can help me or point me in the right direction.
I need to make a pivot table and chart and since a have a lot of info, I'm not exactly sure how to arrange it and how to do it.
Basically I need when I select a certain day and a certain subskill to get a graph with 3 lines in it - info 1, 2 and 3 - at 30 min intervals.
I've attached a file as an example. Any help would be greatly greatly appreciated.
Is this thread solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
sorry, no problem.
basically, I was just a problem arranging all the information I had. If I tried running a pivot on the data that I had, just the way it was, I was getting an error( rookie mistake) that the data must be organized as a list with labeled columns. So I just rearranged the data I had. Book1 (2).xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mynameismada 
Register To Reply
Bookmarks