How to Make a Bar Graph in Excel. ... Check this box to apply a logarithmic scale, ... Use the INDIRECT function to refer to these named ranges dynamically based on the current dropdown selection.

This will give you a set of percentile numbers to make your graph. Select cell C8 and type "Box1." Select cell C9 and type "Box2," then select cell C10 and type "Box3." ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

How to Make a Frequency Distribution Graph in Excel for Mac 2011. You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of ...