Lock progress chart to a specific cell

SirSquiddly

New Member
Joined
Jun 26, 2018
Messages
39
Hi,

I think this might be easy or just not possible.

I am creating a training matrix for my company to drive competence and have started an excel document. The progress charts show progress and will help set targets.

The problem I have is when I insert a new row, adjust size etc, all my data moves but the charts do not. How can I lock them a specific cell that so it moves with it?

Any help will be greatly appreciated.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

ClaireS

Board Regular
Joined
Jul 29, 2013
Messages
137
Select your chart, then go to the Chart Format menu. Click on the "Size and pproperties" icon (squareish in shape) and expand the Properties area. Select "Move but don't size with cells".
 

Watch MrExcel Video

Forum statistics

Threads
1,099,368
Messages
5,468,213
Members
406,572
Latest member
Sidboi21

This Week's Hot Topics

Top