Hi
I have this problem where i am not able to set multiple data source in the chart. I am using this code below and it looks fine but not sure why its still not working. Please help. Thanks
The result should be
Please Login or Register to view this content.
=Data!$R$647:$R$660,Data!$R$647:$R$660
but with the code the result is
=Data!$A$647:$R$660
You may not need VB code at all. This looks like something that could be handled with a named dynamic range. Please attach the workbook with representative but non-sensitive data. OR you can look at these two articles.
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks