I have a bar chart and I have done ctrl+shift to drag the legend to the bottom, which flips it horizontal. However, it defaults to a left-aligned legend which looks weird on my wide chart. How do I center this horizontal legend when the only option I see in legend settings is vertical alignment?
I looked at that, but it only has a vertical alignment and no horizontal alignment selector. When I switch to horizontal legend, I can't find a setting that lets me move the legend to the center of the chart horizontally.
I was searching for an answer to this same question. It's an old post but it has a lot of views, so I've decided to provide a solution that worked for my purposes.
If you are using multiple expressions in a line or combo chart where zero appears on the axis, you can insert an additional expression in the first position with a Definition of 0 (zero), and a label of ' ·' (some number of spaced followed at the end by a "Middle Dot"). You will have to play with the number of spaces.
This is definitely a work around waiting for a UI enhancement,
... forgot to mention that you need to set the background color for the placeholder expression to White() or a color that matches your background. If you don't want the dot to appear in the legend try using a supported non-white space Unicode characters starting at U+2000.
