Tuesday, March 26, 2013

create structure plot using excel

Structure plots: 

Structure or composition plots can be easily created simply by using stacked bars.

Select 100% stacked bar from the column or simply stacked column (however total composition should be 100%).

(2) Select the data range, data in column A to D in this case and specify other graphical options as needed.

(3) Change gap between bars to 0  in format data series and options.

(4) you can turn off the boundary lines of the bars if you like it. other aesthetic value to it.

No comments:

Post a Comment