Hi all,
That's my first post, so I would like to apologize myself if I', doing anything wrong.
I'm having some problems filling between series in a log-log chart. I've tried following the steps that are available at Jonh Petier's website (Fill Under or Between Series in an Excel XY Chart - Peltier Tech) but changing the D5 in his example for =1000*(log(B5)-log(B$11))/(log(B$12)-log(B$11)) and also changing the F5 for =log10(C5) and the G5 for =log10(D5)-log10(C5) but that's not working. Do you guys have any idea why? I've attached a screenshot of the inputs and the resulting plot.
That's my first post, so I would like to apologize myself if I', doing anything wrong.
I'm having some problems filling between series in a log-log chart. I've tried following the steps that are available at Jonh Petier's website (Fill Under or Between Series in an Excel XY Chart - Peltier Tech) but changing the D5 in his example for =1000*(log(B5)-log(B$11))/(log(B$12)-log(B$11)) and also changing the F5 for =log10(C5) and the G5 for =log10(D5)-log10(C5) but that's not working. Do you guys have any idea why? I've attached a screenshot of the inputs and the resulting plot.