[SOLVED] Is it possble that a chart move while you scroll

[luvgreen]

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!!

[HEK]

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

"luvgreen" wrote:

> 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!!

[luvgreen]

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.

"HEK" wrote:

> 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
>
> "luvgreen" wrote:
>
> > 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!!

[HEK]

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

"luvgreen" wrote:

> 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.
>
> "HEK" wrote:
>
> > 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
> >
> > "luvgreen" wrote:
> >
> > > 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!!

[luvgreen]

Thank you Henk. I finally figure it out. I do appreciate your help.
"HEK" wrote:

> 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
>
> "luvgreen" wrote:
>
> > 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.
> >
> > "HEK" wrote:
> >
> > > 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
> > >
> > > "luvgreen" wrote:
> > >
> > > > 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!!