Hi,
I was working on a line graph with alot of data points - first time around I created alot of text boxs.
1. The data in row 33 and 45 should be the "total changes between period" - for example +25 should be in this case +13 and on the bottom +5 should be nothing
2. I wanted to add at the bottom custum data listing of what makes up the changes - for example the +5 would have under the line cells K26:K32 and M26:M32 the bottom should be nothing since no change. The Only thing is if its 0 i dont want it to show, I only want to show changes
Is this possible?
The graph on the right (a picture) is old data but 100 percent same concept, I used this exact sheet when I was making the text boxes one by one!!
Thank you,
Jeffrey
Bookmarks