 | |
| This Excel Chart will grab your attention (Infographic template included) |
Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards.This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel.
Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well.
After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized. As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart.
Related Topics:
Post a Comment