Spatially Formatting a Graph Legend

Hello,

I want to move around individual labels within a legend.

I have a clustered column graph that shows one type of data on the left half, and a second type of data on the right half of the graph. The two data types have their own vertical axes on the right and left. In order to make the legend more clearly indicate which colors correspond to which axes, I want to have the legend labels for the left part of the graph appear above the columns, while the legend labels for the right part of the graph should appear to the right of the plot area and be oriented vertically.

My thought was that I could just make the legend area really big and then move the individual labels around within the legend area to how I wanted them, but Excel doesn't seem to want to let me move them. Is there a way to do this? Or is there a way to split up the legend into 2 portions to achieve this look?

Thank you, and for any links that I may have missed.
-Milktoast

ps. I attached what I'm working with if that will help.

You can create your own legends by using data labels with legend key displayed.

Select a series, then select a data point. Apply data label.
Select data labels, select data label and format and or move.

Thank you, that was exactly what I was looking for.



ps. This probably sounds silly/lazy for a guru of this forum, but having a link from "User CP" that takes you to "my threads/posts" without a user having to subscribe to his own posts or search for posts with his username would be really convenient. And the setting a thread to "solved" was kind of hidden too. An option at the top of the thread in "Thread Tools" or something would be really easy. Of course then there might not be as much need for reading the forum rules...