![]() Equally, don’t use the same colors for different types of data as this can be misleading. Link data points and areas together using the same colors to show they have something in common.Bold colours have more emphasis than lighter shades. Draw attention to a key metric or data point.ColourĬolour is perhaps the most powerful reporting tools we have available because it’s so quickly and clearly conveyed. I personally prefer to have pale borders as this enables me to fit more into my dashboards. You can create whitespace by aligning charts and tables and if you allow adequate space between visuals, you don’t even need borders on your charts. Effective use of white space has been shown to improve content comprehension by up to 20 percent. White space helps readers understand the content better by forming distinct areas in your report. ![]() Gridlines where there are also data labels.Axis titles where the chart title already explains the data.Numeric axes where there are also data labels.Legends that aren’t required because there’s only one series in the chart.Now Tufte would have you remove everything that didn’t fit this strict definition, but I think there’s a balance between using design elements that grab an audience’s attention and unnecessary embellishment and duplicate information. It’s the term coined by Edward Tufte that refers to all visual elements in charts that aren’t necessary to comprehend the data or that distract the viewer from the information. Avoid ChartjunkĬhartjunk is one of the most common issues I see. Note: please see the video for a visual representation of the topics covered below. Excel for Decision Making Under Uncertainty Courseĭownload the Excel Dashboard Workbook and supporting files shown in this video.Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |