Arranging data visualizations on PowerView Canvas

abendretry

New Member
Joined
Nov 15, 2015
Messages
1
Hi,

I am working with 3 data visualizations on my Powerview Canvas. I have them arranged as 2 charts on the left side (Stacked Bar and Pie), and a Bing Map of the West Coast of the US on the right side. I am having trouble getting the visualizations arranged where they will be visually useful but still have all of the fonts on the legend labels showing.

The charts seem to want to be a lot wider than my available space in order for the labels to fully show. I can make the charts really small, but still square, and have enough space, but it just doesn't look right and it is a huge hassle trying to drag them around and resize them.

Is there an optimizer of some kind that will look at my canvas and put these 3 charts as close as possible to where I have them positioned and ensure that all of the legends and labels are visible? By the way, I did try working with the font size on the objects, but, again, it gets too small to be usable.

Any tips or tricks or creative manipulations appreciated!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,224,136
Messages
6,176,562
Members
452,735
Latest member
CristianCaruceriu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top