3/28/2023 0 Comments Excel graph axis label increments![]() ![]() Rather than the smoothed-out appearance in the line above, this style subtly emphasizes that there gains and losses over time. Make sure your markers are relatively small otherwise, the graph can look outdated and clunky. I include markers when I want my viewers to remember that each point represents a different point in time. ![]() Sometimes I add markers (those little circles on top of the lines). ![]() And what the heck happened to Organization B between 20?” Organization A started around 125 and went up to the 175-200 range, and Organization B started in the 25-50 range, got as high as the 100-125 range, but then went back down to the 75-100 range. Both organizations have higher numbers in 2015 compared to 2009. The viewers’ takeaway message might be, “Organization A’s values are always above Organization B’s values. But my viewers can only estimate that value. The viewers won’t see the exact values. In other words, my spreadsheet will tell me that Organization A had a 130 in 2009. Is the line generally going up or going down? Where are the peaks and valleys over time? I use this style when I want viewers to focus on the general, big-picture view. Then, lighten ( mute) the grid lines. Thin gray lines > thick black lines. We need our viewers to focus on the star of the show - the burgundy and orange lines - and not get sidetracked by the backup dancers - the supplemental information like grid lines and tick marks. The increments you choose will likely depend on your unique dataset. In this fictional scenario, I used increments of 25. The trick is strike a balance between labeling too frequently and not frequently enough. The first option is to simply label your vertical y-axis: 0, 25, 50, 75, 100, and so on. With vertical axis labels and light gray grid lines? With labels directly above or on top of the data points? A mix of both? Data visualization is more about strategic thinking than about following steadfast rules. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |