Saturday, March 30, 2013

parallel (dot plot) plot in Excel

In this type of plot (in contrast to XY plot) one axis consists of categorical value while another axis consists of quantative value. The points are usually presented or points are sometime connected with line.

Add line plot with points. See the data arrangement trick to creat a gap in three different group coulmn.



You can add the horizontal lines by clicking drop lines under options menu. Also we can add table to show the actual values against the X axis labels.



We can format to remove lines in table if you think it makes the plot crouded.


If there are not alot of points, you can change data point colors, shapes etc so that they represent group they belong to.  You can remove the data points and plot just lines connecting the points or not removing lines in first place (thus there will be both points and lines connecting points). Of course we can add more than one series by simply adding data series to plots.

No comments:

Post a Comment