scatter plot - MS Excel Scatterplot converts Months to Numbers -


software: ms excel 2016

link files: github repository


sheet2 of month.xlsx has table

enter image description here

when select , insert scatterplot, chart1 of month.xlsx result. no matter try, cannot x-axis display in months (right displays month's number).

help!

enter image description here

enter image description here

the problem way have months stored. looks of things hazard guess text , not numbers formatted display name of month in full. in order months display in graph, either need enter months serial date excel can understand number, or create dummy column hold same information can latter hide.

once have months in serial date excel can handle, can select x-axis , set format style. select custom category, , use mmm or mmmm custom format display name of month. alternatively show whole date using date formats.

two ways enter date serial enter numeric date format matches regional settings or use following formula:

=date(year,month,day) 

where year, month , day integer, or formulas evaluate acceptable integers


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -