Hi,
Please advice how to apply dynamic name list (created by using offset) as chart (line+column) source data.
Thanks.
Last edited by leecs; 06-10-2009 at 09:32 PM.
You can not use an named range as the source data for the chart. If you do it will be converted to array values.
Instead you have to apply the named range to the parts of the each series such as Values, Category labels.
I found this link very useful
http://analysis-reporting.blogspot.c...ic-ranges.html
You have some 6 or 7 images here.
Maybe this site can help
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Perhaps this will help?
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Hi,
Thank you very much. It solved the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks