Hi please look at the image to know what I am trying to do.





I just want to know how I would make the smart-shapes dynamic in Microsoft excel 2013, meaning once I finish putting text into the last shape of that row, to have the next row generate the next 3 or 4 shapes with the correct colors, instead of manually going into insert tab and putting them in myself? If there is a way could someone give me a small demo or link?

Thank you.