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
Bookmarks