The technique I want to share today uses Excel’s ability to use the Category Name as the data label. One downside is that Excel will automatically word wrap some long labels, which may not be the look you want.
You can adjust the Plot Area in the graph to change the proportion of space allocated to labels vs. It got me thinking of how we might be able to use the features of Excel to allow the user to control how much space is used for the category label. But if you are in a corporate environment where you don’t have the option of choosing fonts for your slides or reports, this will not work. If you have the freedom to choose fonts, this can work. One of her solutions for a really long label was to use a condensed font. Recently data visualization expert Stephanie Evergreen wrote about this and reinforced what I suggest. In my workshops I explain how a bar chart is preferable in these situations because it allows for more space for long category labels.
This makes it very hard for the audience to interpret the graph.
How do we create graphs with category labels that contain a lot of text? If you are comparing values to each other, a column graph can get tricky since Excel and PowerPoint will turn the text at an angle and cut off labels that are really long.
0 kommentar(er)
