How to create a dynamic chart off dynamic data
Hey gang! I'm stumped! I am trying to create a dynamic BAR chart that changes with my data. The below is my data set which is dynamic as well. I've tried using OFFSET but i must be doing it wrong and need help ASAP if possible. I need to chart columns B, C, and D. Like i said, all 3 columns are formulas as well. Column B is mapped to a pivot table...when it changes based off slicers, then columns B-D change accordingly, thus my bar chart i need help with will change. HELP!!
forum example.xlsm
Your workbook is locked for editing, I can't do anything with it.
Would this link steer you in the right direction?
http://www.excelforum.com/excel-prog...chart-vba.html
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Jacc, the pw = codastatus. or open it read only. i'd put the file back on here, but dont see how to attach it again. Please take a peek at the file and if you can help me, wonderful. I'm in panic mode. yikes!!! LOL I will take a look at what you sent though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks