How can I make an Excel Stacked Column Chart Legend dynamically adjust to varying rows of data?
Posted on 2014-12-30
I've successfully setup a stacked column chart in Excel which is populated by an SQL script. There's a cosmetic issue with the legend. If the script returns five rows (a maximum for this instance) the graph legend looks great; however, with fewer rows (depending on the output of the script), the graph displays a legend entry "square" with no description.
Is there a way to keep the graph (via a setting perhaps) from displaying the empty legend entry automatically?
I've included a print screen image to hopefully clarify the issue.
Thanks in advance for your assistance!