Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possble that a chart move while you scroll
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!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possble that a chart move while you scroll
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!! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possble that a chart move while you scroll
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!! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possble that a chart move while you scroll
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!! |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possble that a chart move while you scroll
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Putting scroll bars on chart sheet | Charts and Charting in Excel | |||
how to have my titles move down as i scroll down the page | Excel Discussion (Misc queries) | |||
How to move location of chart within a worksheet? | Excel Discussion (Misc queries) | |||
The top six rows are "frozen" and do not move when I scroll down.. | Excel Worksheet Functions |