Resize chart

Resolved · Medium Priority · Version 2010

Fri 31 Jan 2014, 18:01 Delegate Jagparvesh said...

Jagparvesh has attended:
No courses

Resize chart

Which one of the following steps will you perform to resize a chart to a fixed size?
- On the Chart Tools Format contextual tab, in the Size group, in the Shape Height and Shape Width spin boxes, select the height and width of the chart.
- Drag the border of the chart to resize the chart.
- Hold Ctrl as you drag the border of the chart to resize the chart.
- Hold Shift as you drag the border of the chart to resize the chart.

Fri 31 Jan 2014, 18:05 Delegate Jagparvesh said...

RE: resize chart

First option seems correct to me as checked in the word application.

I can also resize the chart from dragging the grouped dots on border of the chart. But those grouped dots won't be called as border, will it be?

Also, is there name for those grouped dots on the border?

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips