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 Elements
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
104. Surface Charts
105. Braving the Elements
106. Graphing Missing Data
107. Recommended Charts
108. A Quick Look at Analysis
109. Asking the Right Questions with Analyze Data
110. Chart Titles as a Text Box Revisited
111. Charting Example – Extended Case Study Part 1
112. Charting Example – Extended Case Study Part 2
113. Charting Example - Extended Case Study Part 3
114. Charting Example – Extended Case Study Part 4
115. Charting Example – Extended Case Study Part 5
116. Charting Example – Extended Case Study Part 6
117. Dynamic Arrays in Charts
118. Custom Axes – Part 1
119. Custom Axes – Part 2
120. Custom Axes – Part 3
121. Vertical Raincloud Chart Part 1
122. Vertical Raincloud Chart Part 2
123. Vertical Raincloud Chart Part 3
124. Vertical Raincloud Chart Part 4
125. The Risk Bubble Chart – Part 1
126. The Risk Bubble Chart – Part 2
127. The Risk Bubble Chart – Part 3
128. The Risk Bubble Chart – Part 4
129. The Waffle Chart
130. Learning our Lines – Part 1
131. Learning our Lines – Part 2
132. Learning our Lines – Part 3
133. Letting Your Charts Take a Break
134. Gauging Success – Part 1
135. Gauging Success – Part 2
136. Histogram Hiccoughs – Part 1
137. Histogram Hiccoughs – Part 2
138. Histogram Hiccoughs – Part 3
139. Working Capital Adjustment Chart in Detail – Part 1
140. Working Capital Adjustment Chart in Detail – Part 2
141. Working Capital Adjustment Chart in Detail – Part 3
142. Working Capital Adjustment Chart in Detail – Part 4
143. The Point and Figure Chart – Part 1
144. The Point and Figure Chart – Part 2
145. The Point and Figure Chart – Part 3
146. The Point and Figure Chart – Part 4
147. The Bubble Pie Chart - Part 1
148. The Bubble Pie Chart - Part 2
149. The Bubble Pie Chart - Part 3
150. The Triangular Distribution Chart
151. The Marimekko Chart – Part 1
152. The Marimekko Chart – Part 2
153. The Marimekko Chart – Part 3
154. The Marimekko Chart – Part 4
155. The Horizontal Raincloud Chart – Part 1
156. The Horizontal Raincloud Chart – Part 2
157. The Horizontal Raincloud Chart – Part 3
158. The Horizontal Raincloud Chart – Part 4