Best Microsoft Excel Bloggers

Friday, October 14, 2016

12 Months Data -13 Months Data in a Chart

An interesting Excel feature is that as you make the 12-month chart smaller and smaller, Excel drops the last (right-most) label from the X axis although the column or line still may appear in the chart itself. So, you may want to consider including thirteen months of data when putting together your dashboard.

1 comment:

  1. Hi Patricia -

    When I read this, I wasn't sure at first what you meant. But then I thought about it, and played with it, and wrote a blog post about it, in more detail and with a couple extra workarounds. See Axis Labels on Small Charts.


Ms. Excel- Resident Excel Geek