It’s easy, if tedious, to correct the order of category axis labels. The labels were sorted from top down in the worksheet, but they appear from bottom up along the chart axis. Let’s use some very simple data to illustrate the problem. If you are really interested, I finish with an explanation of why this happens. I describe the problem and how to correct it. I’ve answered the question a number of times, but if I answer it here, it will become available for the ages. I have been asked this question a number of times, and being a founding member of Chart Busters, of course I know the answer. ![]() ![]() Alex works on projects in analytics and dashboarding. I came across a blog post called Is it just me? (software defaults), which asks the age-old question, Why Are My Excel Bar Chart Categories Backwards? The post was in a new blog by Alex Kerin of Data Driven Consulting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |