Hope someone can help me out. I have a Contribution Analysis of the food items in our Innovations dining section. Currently, I manually plot each of the 'codes' onto the attached chart. The reason for doing this manually is that the number that is plotted has a specific reference to the food item.
So, if we look at the attached, very first item is 'Farfalle DeSalvo Pollo' - with a Y-axis of 14 and a X-axis of 11. So, within those cordinates, a '1' will appear for the food item 'Farfalle DeSalvo Pollo'.
Is there anyway to automate this process? I do this process for 6 other graphs - same concept and it is very time consuming.
Thanks in advance for any advice.
Bookmarks