I have smart tag in a cell that displays a list of data when ran. There is a pie chart linked to that smart tag that displays the data in the chart. So that all works fine. My requirement is to have the legend in excel show only colors and not data items due to formatting restrictions in Excel. I was thinking of not using a legend and create excel shapes (little triangles), assign them colors to match the colors in the pie chart, load them into a list or table and display the list of shapes using a smart tag.
Can this be done?
Attached is an example