Basic Excel Chart Skills
-
Use critical thinking skills to accurately interpret a graph (& create accurate graphs yourself)
When you look at a graph, you immediately interpret the message using the visual cues in the graph. If one column is twice as tall as another column you deduce that the value of the taller column is double that of the shorter column. When looking at graphs we need to use our critical thinking… Continue reading Use critical thinking skills to accurately interpret a graph (& create accurate graphs yourself)
-
Force a column, bar, or line chart in Excel to start at zero
Excel changes the starting value for the measurement axis of column, bar, and line charts based on the values being graphed. This can cause a chart to be misleading just because the data got updated. In this video I show you how to add a second invisible data series that forces Excel to always start…
-
7 steps to make one line stand out in a spaghetti line graph
If you have a line graph with many lines and you want to focus the viewer on one of those lines, how can you do that? Here are 7 steps you can follow to make one line the focus in what is often called a spaghetti line graph (because the many lines can look like…
-
8 steps to make a professional looking bar chart in Excel or PowerPoint
A bar chart is used to rank values from largest to smallest, usually in a single series of data. Creating a bar chart in Excel or PowerPoint is simple, but making it look professional requires you to change some of the defaults in the chart. Here are 8 steps to turn a default bar chart…
-
7 steps to make a professional looking line graph in Excel or PowerPoint
A line graph is used to show a trend, usually over time. There can be a single data series to show one trend or multiple data series to show trends that can be compared to each other. It is simple to create a line graph in Excel or PowerPoint but to make it look professional…