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.



2 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