Create Amazing Percentage Chart in Excel


Today I am going to cover how to create a percentage chart in excel.

Download the workbook used in the example shown above.

Percentage Chart

It allows you to create your own chart by entering percentage.

Steps

1. Select 10 Rows and 10 Columns (10 X 10 Matrix). Let's say G7:P16.


2. Shade to cells by filling them with black color and apply border to the cells (All Borders).

.

 3. Enter a percentage value in cell D3.



4. Select G7:P16 cells and apply conditional formating using a formula.

Go to Conditional Formating >> Select "New Rule" >> Select "Use a formula to determine which cells to format"

And put the following formula in the formula box.

=((ROW($P$16)-ROW())*10+COLUMN()-COLUMN($A$1)+1)<=ROUND($D$3*10^2,0)
ROW(P16) => Last row of your matrix. It returns 16.

COLUMN(A1) => First column of a sheet. It returns 1. It will always be the same no matter matrix is placed.

D3 => Cell in which your percentage value is placed


Final Step

After pasting the above formula, click on Format button that appears just below the formula box >> Select Fill >> Select Light Blue color >> OK


Related Posts
Spread the Word!
Share
About Author:
Deepanshu Bhalla

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

0 Response to "Create Amazing Percentage Chart in Excel"

Post a Comment

Next → ← Prev
Looks like you are using an ad blocker!

To continue reading you need to turnoff adblocker and refresh the page. We rely on advertising to help fund our site. Please whitelist us if you enjoy our content.