Per your request, I have added an abridged test file that has the same characteristics.
Per your request, I have added an abridged test file that has the same characteristics.
Last edited by walt007; 01-29-2015 at 05:57 PM. Reason: Request for further information
Walt,
Would you mind posting the Workbook you're using?
If I have helped you, please add to my reputation!
Your x values are text so for a xy-scatter chart they are converted to incremental values starting at 1. Numbers 1 to 12 displayed as months returns Jan for all values.
either use actual dates, 1st of each month, if using a xy-scatter.
Or change chart type to Line and on the horizontal axis set Postion axis "on Tick marks"
Thanks for the solution Andy.
First solution with the xy scatter chart type didn't work. Second solution, changing to a line-type chart worked and displayed the proper sequence of months.
The question to myself is 'why'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks