This makes it look like the shape is inside the chart even though it is not. The confusing part is that a shape residing outside the chart on the worksheet can be placed on top of the chart.
Shapes, such as a text box or rectangle, can reside in two places: Moving shapes inside a chart can get a bit confusing. The bounding box will still look like the same as when you only have one chart selected, but you are able to move the charts with the arrow keys. Select multiple charts or shapes – Hold the Ctrl key and select at least two charts using left click. The chart can now be moved around on the sheet with the arrow keys, making it easy to align it with other shapes, charts, or cells in your worksheet. Circles will appear on each corner of the chart. Hold Ctrl and Left Click the chart – This selects the shape object that the chart resides in. Instead, the objects within the chart are cycled through and selected. When the chart is selected like this, nothing happens when you press the arrow keys to try and move the chart around the worksheet. Typically when you select a chart with your mouse, the box surrounding the chart looks like the following.
#EXCEL SHORTCUT KEYS CHART FREE#
I also have a free Chart Alignment add-in that allows you to move the objects inside a chart (titles, labels, legends) with the arrow keys and alignment buttons. This is very useful when you need to arrange and align multiple shapes on your worksheet. This post and video contain lots of tips for moving your charts and shapes with the arrow keys.
0 kommentar(er)
