Thread: [Solved] Using certain values in custom number format for vertical chart axis?
View Single Post
 
Old 08-02-2021, 11:31 PM
laith93 laith93 is offline Windows 10 Office 2019
Competent Performer
  
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
When the sum of the numbers varies you would use a formula like the following in I2
=100*B2/Sum($B2:$D2)

You can then copy that formula across and down to build the table.
Thanks my bro
Reply With Quote