How to have a chart showing no FLAT area?
Hello!
I have this chart that shows a FLAT area of the same "Balance" beginning with "Deposit" number 8 (see attachment). What I would like to have for this chart is NOT to show that FLAT area if there is the same balance. If there are any changes in the Balance with the next deposits, then of course I would like to see continuation of that chart. How to do it?
Can someone have any ideas, or suggestions?
Thank you for all your help!
Possibly use a helper column, say F, to check if balance changes and return the last change greater than zero.
F2: =(E2<>E1)*1
create a dynamic named range "Balance":
Use the name for the series values: =Sheet1!Balance, or
Please Login or Register to view this content.
=Book11.xlsx!Balance
Ben Van Johnson
Thank you Ben, but that does not solve it. If you extend the formula beyond #11, the chart will have the same flat area.
Try
in the helper column.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks