I have an year on year + month on month line graph. To add a reference line I had to convert MONTH() into a continuous axis. Even though the reference line recognizes the value 10 as October, I can't figure out how to display the entire x axis with names of months. Could someone help me with getting the x-axis to display January to December?
4 answers
Hi Nick,
Right click month and select Format-> Scale -> Dates-> Select the desired label type
Hope this helps.
Soham
