Skip to main content

Choose the Right Data Visualization for Numbers

 

Only numbers - Showing Numbers in visuals

 Sometimes, just showing the data as text is the most effective

way of conveying information.

Single value chart



When you just have one number, it’s best to just report

it as-is. Plotting a single value graphically (such as with a

bar or point) usually isn’t meaningful if there aren’t other

values to compare it to.


Single value with indicator



An indicator compares the single value to a second

number. This is often to compare a metric’s value between

the current period and the previous period.


Bullet chart



Chart type comparing a single value to another number,

often a benchmark rather than another data point. The

single value is shown with a bar’s length, while comparison

points are shown as shaded regions or a perpendicular line.


Table



Compares data points (rows) across multiple different

attributes (columns). Usually sorted by an important or

prominent attribute to improve utility.



Labels:

Comments

Post a Comment

Popular posts from this blog

Year Over Year calculation using Pivot Table

Instead of creating a formula outside of the pivot table, you can do this inside the pivot table. Start from the image with column D empty. Drag Revenue a second time to the Values area. Look in the Columns section of the Pivot Table Fields panel. You will see a tile called Values that appears below Date. Drag that tile so it is below the Date field. Your pivot table should look like this: Double-click the Sum of Revenue2 heading in D4 to display the Value Field Settings dialog. Click on the tab for Show Values As. Change the drop-down menu to % Difference From. Change the Base Field to Date. Change the Base Item to (Previous Item). Type a better name than Sum of Revenue2 - perhaps % Change. Click OK. You will have a mostly blank column D (because the pivot table can't calculate a percentage change for the first year. Right-click the D and choose Hide.
Post a Comment
Read more

Power Point - Slide Master a very important tool

  When you want all your slides to contain the same fonts and images (such as logos), you can make those changes in one place—the Slide Master, and they'll be applied to all your slides. To open Slide Master view, on the   View   tab, select   Slide Master : The master slide is the top slide in the thumbnail pane on the left side of the window. The related layout masters appear just below the slide master (as in this picture from PowerPoint for macOS): 1  Slide master 2  Layout masters When you edit the slide master, all slides that are based on that master will contain those changes. However, the majority of changes that you make will most likely be to the layout masters related to the master. When you make changes to layout masters and the slide master in Slide Master view, other people working in your presentation (in Normal view) can’t accidentally delete or edit what you’ve done. Conversely, if you're working in Normal view and find that you'...
Post a Comment
Read more