Tuesday, April 2, 2013

3D-histogram in Excel


Histogram can be both 2D and 3D. By 3D I do not mean 3D bars rather threre are two variables (X and Y and frequency is plotted in Z axis).

After  preparing data category (see the article), we can create a 3D histogram. So we need a two way frequency count table  like this:



The insert 3D column chart. We can then modify this remove gaps (looks like a block).


We can creat columns with different shape( may be just for fun !).




We can change the type to 3D- wire frame plot.



4 comments:

  1. You are excellent. Your post about 3D-histogram in Excel is in very details.In a word,i'm just new to this filed.I met a lot of problems in my work,your article is written very well, there is a lot of very useful knowledge to help me solve problems.I enjoy reading your article and hope to see more.


    Labels: 3D plot,excel barcode, histogram, wireframe plot



    ReplyDelete
  2. Hi. Great chart. I would like to add two dimensions, i.e. the width of the column could be one and the colour of it could be another (i.e. shades from yellow to green). Is that possible?

    ReplyDelete
  3. A 3D Warehouse Heat Map in MS Excel (by Adrián Chiogna).
    https://es.slideshare.net/HECTORADRI/a-3d-warehouse-heat-map-in-ms-excel-by-adrin-chiogna

    ReplyDelete
  4. Nice information on here, I would like to share with you all my experience trying to get a loan to expand my Clothing Business here in Malaysia. It was really hard on my business going down due to my little short time illness then when I got heal I needed a fund to set it up again for me to begin so I came across Mr Benjamin a loan consultant officer at Le_Meridian Funding Service He asked me of my business project and I told him i already owned One and i just needed loan of 200,000.00 USD he gave me form to fill and I did also he asked me of my Valid ID in few days They did the transfer and my loan was granted. I really want to appreciate there effort also try to get this to anyone looking for business loan or other financial issues to Contact Le_Meridian Funding Service On Email: lfdsloans@lemeridianfds.com / lfdsloans@outlook.com He also available on WhatsApp Contact:+1-9893943740.

    ReplyDelete