Quickly set the absolute position of a chart in Excel

When you create a chart in your worksheet, the chart will be displayed at the center of the worksheet, if you want to put the chart into a specified position precisely, normally, you can move and drag the chart manually. But, here, I will introduce an easy tool - Set Absolute position of Chart of Kutools for Excel, with this handy utility, you can put the chart to a specified location quickly.

Set the absolute position of a chart in Excel

Set the absolute position of a chart in Excel

Supposing, you have a chart in your worksheet, to put it into a specific position precisely, please do with the following steps:

1. Click to select the chart that you want to set the absolute position, then, click Kutools > Charts > Chart Tools > Set Absolute position of Chart, see screenshot:

2. In the popped out Set Absolute position of Chart dialog box, select the range of cells where you want to put the chart from the Move to text box, see screenshot:

3. And then, click Ok button, the selected chart will be moved to the specific position at once, see screenshot:

Notes:

1. If you check Hide axis labels option in the Set Absolute position of Chart dialog box, the vertical and horizontal axis labels will be hidden as below screenshot shown:

2. This feature does not support Undo.