Hi guys,
I have been working on a dynamic way to create a bargraph where the data can be updated and modified over time which will change the appearance of the graph e.g. If I add a new row it will feed that data into the graph.
I have managed to do this successfully when the data is organised vertically e.g. Data column which has the dates underneath it and a sales column with the amounts underneath it. I have also created two drop down buttons which can sort the graphs by dates e.g. specify data between month x and month y.
see this link - in the post
The problem I am facing is when I have data organised in a horizontal fashion I can't get my offset functions working correctly. e.g. I have date columns e.g. Feb-10 Mar-10 and vertically I have project 1,2,3 etc
see link - http://img684.imageshack.us/img684/3073/seconddata.jpg
FYI here is the formulas I used for the Date & Sales Graph
Xrange - =OFFSET(Graph!$A$1,0,0,COUNTA(Graph!$A:$A),1) Yvalues - =OFFSET(Graph!$A$1,Graph!$G$1-1,0,Graph!$G$2,1) Xvalue - =OFFSET(Graph!Xvalues,0,1)
Any help would be appreciated! Thank you!