Graphs There are a large number of graph types, but these are the most commonly used. Single variable scatterplotSingle variable scatterplot with INDEX()Single variable column chartHistogram ChartHistogram (using the Data Analysis Toolpak)Histogram using the FREQUENCY() functionFREQUENCY() histogram with INDEX()XY ScatterplotXY Scatterplot using INDEX() Next Page: Useful Excel Functions