Add a dot plot as native graph option. This is a simple graph that shows position of datapoint on a single axis for data visualization.
Dot plots are simple graphs that show distribution of values along a single axis. This can be faked using a scatterplot, but the y-axis is unused (and people always ask what that axis is...) Programs like Minitab allow for this graph to help visualize the data without any statistical assumptions.
Willard
shared this idea
2 comments
-
Rick Lawrence
commented
You can always remove the y-axis and its labels from a scatterplot,
CHART DESIGN > ADD CHART ELEMENT > AXES > uncheck Primary Vertical -
Marshall
commented
This would be really really helpful for economists -- the Fed publishes a "dot plot" every quarter of the FOMC members' forecasts of interest rates. It's one of the most widely viewed graphs in the economic field, and it's really hard to make in Excel (although there is a workaround -- see http://crispexcel.com/fomc-dot-plot-chart-using-rept-function/ )