lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I am watching a video on how to insert a variant chart (showing negative and positive). The author used the table below. The formula she used to find the difference is
=(B2-C2)/C2
Why is that? why not
=(B2-C2)/B2
Thanks a lot.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am watching a video on how to insert a variant chart (showing negative and positive). The author used the table below. The formula she used to find the difference is
=(B2-C2)/C2
Why is that? why not
=(B2-C2)/B2
Thanks a lot.
company name | sales | sales-previous year | different |
company1 | 600 | 795 | -25% |
company2 | 845 | 812 | 4% |
company3 | 841 | 797 | 6% |
company4 | 362 | 441 | -18% |
company5 | 349 | 492 | -29% |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>