Hi,
I have the following data with 23 departments.
The row one department cells are merged.
testdata12.png
I am trying to make two charts using VBA; one for Actual and one For % of total by the following code. I am getting two graphs until in the For loop of i Column the values do not exceed 35 and 36 respectively in place of 29 and 30 respectively. As I exceed the values 35 and 36 resp, it shows 'Series Formula Too Long' error and the grphs are not plotted. Please tell me why this is happening and what is the solution for the same.
Thanks.
Kindly find the image at http://peltiertech.com/images/2015-0...tsPartDeux.png My data set has 23 pcts and acts.
I have also posted my question on other forums as follows:http://stackoverflow.com/questions/3...-in-vba-charts
http://www.excelkey.com/forum/viewto...p=22008#p22008
http://www.ozgrid.com/forum/showthre...574#post750574
http://www.mrexcel.com/forum/excel-q...ml#post4203489
http://stackoverflow.com/questions/3...-in-vba-charts
Bookmarks