Chart Location

[Broxterman]

Is there a way to assign a chart to a specific cell range so that i
will fill that area perfectly, as opposed to manually dragging th
lines to fit an area.
Thanks for the assistanc

 

[Jon Peltier]

In the middle of the following page, I have a link to
InteractiveChartResizer, a utility that will let you select a chart,
push a button, then select the range of cells that you want to fill with
the chart:

http://peltiertech.com/Excel/Charts/InteractiveChartCreation.html

If you hold the Alt key while moving and resizing a chart, its edges
will line up with the cell boundaries, without making you squint.

- Jon