I don't know that I'm totally following this. Is there any way you could mock up a sample that repros the issue? I'd kind of like to see it in play.
I'm also curious, what versions of Excel and PowerPivot are you running?
Hi,
I have created a clustered bar chart and want to show all my data labels at the far right hand side of the graph (all in a column). I've manually moved them all but when I refresh the graph data (using powerpivot slicers) the labels all move again.
Is there a way to fix the labels so they don't move?
Thanks,
J
I don't know that I'm totally following this. Is there any way you could mock up a sample that repros the issue? I'd kind of like to see it in play.
I'm also curious, what versions of Excel and PowerPivot are you running?
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Thanks for taking the time to respond to me.
I've mocked up a sample in the attached (hope it works!). With month "7" selected on the slicer the labels all line up where I put them, however when I change the month it goes all funny.
I'm using Excel 2010 and Powerpivot 10.50.2500.0
Thanks,
J
The data labels once manually position will still maintain the related movement with the data point.
You could use code to reposition the data labels or you could add some additional series and put them on the secondary axes.
Set the data labels to the new series to be inside base, which will be a non moving location.
Example 1058.xlsx
Bookmarks