Tuesday, April 2, 2013

Point graph in Excel

A simple graph where only single variable is plotted in one axis with points and each point are space based on the value.

Here we need to create XY scatter plot , where we add dummy values to X or Y axis, depending upon whether we want to plot toward X or Y axis.

Now w want to center the points, just chanve the limits in Y axis from 0.8 to 1.2. We can hide the Y labels, that we do not need.
In similarway we can create multiple series of point plots. Here we need dummy X series (or Y series depending upon direction of points to be plotted).

No comments:

Post a Comment