![]() ![]() On the Axis Options menu change the Axis Type from Automatically select based on data to Text axis.The trick with this is to trick Excel into thinking that there are not days missing, we do this by getting Excel to treat the data in question as plain old text. I usually find that things like this happen when my data set is looking at week commencing intervals or the first day of the month and Excel assumes that there are a number of days missing form my data set when in fact there aren’t at all. ![]() I think it looks like something is missing somehow or just downright untidy. Gaps can be good, – sometimes – but not always on the Axis of your Excel chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |