I have anywhere from 2 to 10 values that are charted in a scatter plot, and the number of values is never set. Currently, when the number of values changes, I have to edit the Source Data to reflect the change.
Is it possible, without macros, to dynamically update the source data based on the number of available values?
Thanks,
Nick
Is this source data consecutive (ie. A2:A5 (4 values), A2:A10 (9 values) ) or are there gaps (A2,A5, A7, A10 (4 values), A2:A10 (9 values)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks