Hello forum,
A little out of my league here with Labels that aren't being used within charts. The attached workbook has my example that I'm hoping will make more sense.
I am trying to create a scheduling tool that will adjust label sizes according to Start and Finish dates that are given in columns C and D. A code a colleague of mine has produced seems to do the trick, but with static ranges. I'd like for a loop to cycle through column A, and bin the necessary fruits according to column G, and have the label code (or some variant thereof) execute and incorporate a new label for each piece of fruit, signaling it's duration or shelf life.
Label code given below:
Hopefully this explanation wasn't clear as mud!?
Bookmarks