如何使excel內的圖表跟著走?

2007-07-12 1:04 am

我在excel一張wroksheet內做了一個chart, chart旁邊有一系列既表, 用作入data, 因此表既data好長, 我每次都要scroll落去先入到資料, 但一scroll落去後就唔能夠即時睇到個圖表既變化, 每次都要scroll返上去先睇到, 好麻煩, 請問有無方法可以使我scroll個列表時, 幅圖表可以跟住一齊落呢?
希望你地明我問乜啦~~thanks各位~~

更新1:

我試過freeze同split個panel都唔得啊~~~希望大家幫到我 .

回答 (2)

Keith

2007-07-12 1:18 am

✔ 最佳答案

For example, your chart area (not data area) is A1:G10 and your date area is A10:B100.

Click on the cell A10, then select Data, Freeze Pane.

Hope this helps.

2007-07-11 17:20:15 補充：
If you still cant make it by using the above method, go to this web site www.excelforum.com. There are many excel professional there that can help you. You could provide an example file there also.

參考: my knowledge

👍 0 👎 0

San

2007-07-12 1:08 am

我諗就冇咁先進喇
不過我有另一個好少少既提議
就係係可以加chart果時唔加響同一張sheet度
雖然都要禁多幾下,但總好過scroll黎scroll去好

參考: me

👍 0 👎 0

收錄日期: 2021-04-24 09:14:53
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070711000051KK02980

檢視 Wayback Machine 備份