What im asking is I believe called defined names. I have basic understanding to Excel usage and I love the software. Given in I have data that looks like this:
Date | Value A | Value B | Value C
1.1.2019 | 20 | 20 | 20
2.1.2019 | 22 | 21 | 20
3.1.2019 | 23 | 25 | 26
Im looking to create line graph that updates automatically when you enter new data rows - one graph for each value. I already tried using OFFSET and COUNTA functions with no luck. Any tips?
As commented by @ReyJuna, seems that there are way easier solutions than OFFSET&COUNTA.
(However, note that removing rows from data does not trigger correct line graph ranges)
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다