Good Morning,

I am currently working on a spreadsheet which shows our product sales for the last 3 years. (attached)

My problem lies when I try to freeze the panes from Cell E30 on 'Door' (ignore 'All' that is my figures sheet)

I freeze the panes, this holds Row 29 in place, Which I Want.

But upon holding colum E as I try to scroll to the right, the line chart moves with it.

My question is:

Is there a way I can scroll through the figures, keeping columns A-C in place(D is hidden) and allowing the line graph to stay in view?

Many Thanks
Ross



BreadButter2 - COPY.xlsx