I am having real problems with a legend on a chart - please see it attached.
I am aware of ctrl + shift but for the life of me can't get all the legend options to show along the bottom of the chart.
Solved! Go to Solution.
Press ctrl+Shift simultaneously....
Red rectangular border will appear around Legends...Then Drag That rectangle to Top Border/bottom Border of your chart untill Top Border/Bottom Border of both Legend's Border and Chart border Matches....
You will notice that Legends are now Horizontal.
Follow this steps
Step1: Click on Reset User Sizing & Reset User Docking buttons in General tab & OK
Step2: Now hold Ctrl + Shift buttons and drag to the bottom until you see the highlighting rectangle/square
Hope this helps you.