When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

Often when creating excel documents we rush or jam our keyboards in frustration. Sometimes are fingers run from us and type values in hidden unknown depths of excel. Many times, #Value! errors occur ...

Open a new Excel spreadsheet. Click cell A1 and type "Data Set" into the cell. Click cell A2 and type in the first value for the data set that you want to make into a percentile graph.

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you're tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.

If you are dealing with data involving comparative analysis of values spread across 2 different columns, try using the Line Chart or the Scatter Plot Graph. The procedure to create a line chart ...