Skip to main content
100%

James Eanes - VI5

✓ Published0🌍 Public
JJamestiberiuseanes
Last edited Feb 20, 2016
Created on Feb 20, 2016

This example contrasts an unjustified 3D Excel line chart with its standard 2D counterpart, using passing yards data from a football dataset. It demonstrates how the 3D version introduces perspective distortion and occlusion, making it harder to identify peak values despite adding no structural insight. The second chart, a plain Excel line graph, conveys the same data clearly and effortlessly. The visualizations are created entirely in Microsoft Excel, relying on its native charting capabilities rather than any external libraries.

AI-generated description

James Eanes - VI5

I used Excel to demonstrate unjustified 3D (perspective distortion), using the passing yards data from the football dataset. The rule of thumb is to not use 3D unless it is justified, typically only in cases where there is a benefit in seeing the structure of a dataset (e.g., wind tunnel data; architectural designs; etc.). Using 3D without good reason can lead to problems understanding the data being visualized, inluding perspective distortion and occlusion.

The first figure below shows Excel's attempt at turning a simple line graph of passing yards into 3D; it clearly provides no additional value and distorts the line graph; specifically, it takes extra effort to verify the highest data values due to the angle of the axes. The second figure shows a standard line graph in Excel, which is simple, easy to understand, and all that is necessary for this data.

Unnecessary 3D in Excel

unnecessary3d

Standard Line Graph in Excel

standardgraph

Similar vizzes