Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I'm not sure if this helps anyone, but you can get a sort of workaround by the method used in this post.

I changed the Range for Name field of the first Data Series from "$Sheet1.$A$2" to "$Sheet1.$A$1:$A$2". Note that this requires expanding the physical footprint of the legend. Results are as below. It's not the prettiest solution, or the ideal one, but hopefully it helps someone.

image description

By filling the Subtitle field, and using the original Range for Name field, I get something that looks more like this. Depends on your preferences, I guess.

image description