Is it possble that a chart move while you scroll

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A table has many fields, the chart location above the table on the same
sheet. While scrolling to see the data in the table, the chart is not
visible. Is there a way to keep chart always show as you scroll? Thanks much!!
 
Put the chart in a high region of your worksheet and select a cell in a row
under the chart. Go to the menu and click Window / Freeze Panes. The region
above and left from the selected cell are frozen (remain visible) when you
scroll. To undo, go to Window / Unfreeze panes.
GL,
Henk
 
Thank you much. the chart is pretty big, and if I freeze the left pane, the
data in the table on the left pane will always show, I can only see one
column of data in the right pane when scroll. I don't know if there is any
other way? thanks.
 
If it only the chart you want to keep visible while scrolling I don't see
your problem. You can make the left region effectively non-existing by
selecting a cell in column A (below yr chart). However, if you want
row/column headings to keep visible while scrolling you can select the cell
just in the corner where the rows/cols cross).
An alternative is to open a new workbook and display it side-by-side with yr
workbook (Open both workbooks and go to Window/Compare side-by-side). Copy
the chart to the new workbook (keep the links) and make this copy of the
chart as small as approriate. Shrink the window of the new book to the size
you want. Any changes to yr workbook will also be refledcted in the new
chart. However, I think the freeze panes option is easier.
GL,
Henk
 
Back
Top