|
楼主 |
发表于 2021-6-24 03:14
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
外网看到这位的回复:
Robert5205
Mace
Robert5205 This person is a Verified Professional Jun 24, 2017 at 3:23 AM
Knowing the limitations of Excel and logs, if I were doing this, I might do it this way.
1. Pre-process my own data.
new_value = if(old_value=0,0,log(old_value))
2. Create a (now) linear graph scale and set the y-axis labels manually to 0,1,10, etc.
3. Plot the new_value.
也不是很理解new 和old value的意思和这个思路怎么实操... |
|