You arrange your data horizontally with each data point in its own column (i.e. In the picture below, this is showing above B39, as I have transposed your original dataset, but the formula was pointing at your original vertical dataset. To see all data points, with data that are whole numbers, then 1 should do it, but may become very crowded, so a trade-off.Ģ) To stop the re-ordering of your dates: The trick is to convert your dates to text using =TEXT(A2,"dd/mm/yy") where A2 is a data point for the X axis etc. You would need to convert the dates to text and plot as a line chart without the line.ġ) Right click X axis and set the major interval to a balance between the amount of detail you want to see and that which is legible. 1) You can't see all your data labels on the X axis unless you format the X axis to have major interval of 1.Ģ) With a scatter plot, you cannot have your original labels retained on the X axis and, in your case, as your dates are recognised, they are ordered as such.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |