• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do we plot triangles/polygons in excel

Bhavesh Agarwal

New Member
Hi All,

I am new to this forum, but have been a follower of excel teachings by Chandoo. Special thanks to Chandoo for putting up so much useful information online for us to learn!

My query is --> As a comparison chart, can we plot percentages/numeric values as area of triangles or other shapes. Basically for example, there would be a small triangle with area of 10%, next would be of 35% and biggest would be a 100% area triangle...

I have tried a lot of different ways to do it in excel, but didn't get it...
Any help would be appreciated!

Thanks!
Bhavesh Agarwal
 
Hi Bhavesh ,

I would advise against it.

It is more difficult to estimate the areas of shapes than it is to estimate the heights / lengths of bars.

A simple column / bar or even a line chart can be more informative than an area chart.

How exactly can a user appreciate that one value is one and a half times another value , given two triangles or polygons ?

Given two bars , one can easily estimate that one bar is one and a half times another bar.

Narayan
 
Bhavesh,
Firstly, Welcome to the Chandoo.org Forums

I agree with Narayan's comments

why:

because of this

upload_2018-3-7_22-58-52.png

Those are your 3, 10%, 35% and 100% Triangles

Do they really assist the reader to understand what is going on ?

To see how they are made please see attached file:
 

Attachments

  • Triangle Chart.xlsx
    14.7 KB · Views: 2
Back
Top