Please note javascript is required for full website functionality.

Charts and Dashboards Blog Series

Charts and Dashboards Blog Series

Here is the complete list and respective links to all of our Charts and Dashboards blogs.

  1. Getting to Know Charts in Excel
  2. How to Create a Chart
  3. Understanding Chart Element
  4. Chart Design Best Practice – Part 1: Which Chart When?
  5. Chart Design Best Practice – Part 2: Colours and Compositions
  6. Chart Design Best Practice – Part 3: Memorable Charts
  7. Chart Tools – Contextual Tabs (Part 1)
  8. Chart Tools – Contextual Tabs (Part 2)
  9. Line Charts
  10. Column Charts
  11. Bar Charts
  12. Pie Charts
  13. Pie of Pie Charts
  14. Scatter Charts
  15. Radar Charts
  16. Sunburst Charts
  17. Treemap Charts
  18. Stock Charts
  19. Box and Whisker Charts
  20. Introducing the Camera Tool for Dashboards
  21. Funnel Charts
  22. Waterfall Charts – Part 1
  23. Waterfall Charts – Part 2
  24. Introduction to Data Ranges and Data Tables
  25. PivotChart – Part 1: Creating a PivotChart
  26. PivotChart – Part 2: Interactivity
  27. Highlighting Data
  28. Hiding Data - Part 1
  29. Hiding Data - Part 2
  30. Dynamic Charts – Part 1
  31. Dynamic Charts – Part 2
  32. Dynamic Charts – Part 3
  33. Interactive Charts – Part 1: Form Controls
  34. Interactive Charts – Part 2: Form Controls (Continued)
  35. Interactive Charts – Part 3: Data Validation
  36. Interactive Charts – Part 4: Introduction to ActiveX Controls
  37. Dashboard Workbook Layout – Part 1
  38. Dashboard Workbook Layout – Part 2
  39. Dashboard Workbook Layout – Part 3
  40. Dashboard Design – Using Tables and Conditional Formatting
  41. Sparklines
  42. Symbol Charts – Part 1
  43. Symbol Charts – Part 2
  44. Linking Excel Charts to Power Point
  45. Multiple Bullet Charts – Part 1
  46. Multiple Bullet Charts – Part 2
  47. Rolling Charts
  48. Dynamic Chart Titles
  49. Dynamic Chart Labels
  50. Dynamic Simulation Charts
  51. Working Capital Adjustment Chart
  52. Customised Chart Shapes – Part 1
  53. Customised Chart Shapes – Part 2
  54. Dynamic Chart Labels for Stacked Column Charts
  55. Bullet Charts – Part 1
  56. Bullet Charts – Part 2
  57. Bullet Charts – Part 3
  58. Conditional Donut Chart – Part 1
  59. Conditional Donut Chart – Part 2
  60. Conditional Donut Chart – Part 3
  61. Dynamic Legend
  62. Moving Chart Labels – Part 1
  63. Moving Chart Labels – Part 2
  64. Chart Titles as a Text Box
  65. A Bar Chart with Dynamic Ordering – Part 1
  66. A Bar Chart with Dynamic Ordering – Part 2
  67. Target Practice
  68. More Target Practice
  69. Marking Milestones - Part 1
  70. Marking Milestones - Part 2
  71. Great Gantt - Part 1
  72. Great Gantt - Part 2
  73. Problem Solving with Pareto Charts
  74. Pareto Plus
  75. Pareto Power
  76. Sales Funnel Chart – Part 1
  77. Sales Funnel Chart – Part 2
  78. Step Chart
  79. Thermometer Chart Part 1
  80. Thermometer Chart Part 2
  81. Sparkling Sparklines Part 1
  82. Sparkling Sparklines Part 2
  83. Venn Diagrams Part 1
  84. Venn Diagrams Part 2
  85. Venn Diagrams Part 3
  86. Time-Saving Template
  87. Presentation Pitfalls Part 1
  88. Presentation Pitfalls Part 2
  89. Presentation Pitfalls Part 3
  90. Conditional Chart Labelling – Part 1
  91. Conditional Chart Labelling – Part 2
  92. Conditional Chart Labelling – Part 3
  93. Conditional Chart Labelling – Part 4
  94. Creating Comparable Charts - Part 1
  95. Creating Comparable Charts - Part 2
  96. Tornado Charts - Part 1
  97. Tornado Charts - Part 2
  98. Tornado Charts - Part 3
  99. Data Tables - Part 1
  100. Data Tables - Part 2
  101. Data Tables - Part 3
  102. Data Tables - Part 4
  103. Data Tables - Part 5

Newsletter