There is no formula anywhere. The idea was to use named ranges, and in the reference to the named ranges is where you use the formulas provided. Then you edit the data series of the chart to refer to the dynamic named ranges.Originally Posted by shawn22
The attached does not fully reflect that as Sweep probably wanted to leave some fun for the OP. The named ranges for Months included up column K as well, so I corrected that and included up col AA similar to the sales range.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
alis88 
Register To Reply
Bookmarks