Sorting Series AND Date (X Axis)
I'm trying to have the series' legend sorted alphabetically (which almost every other system automatically does) AND show the dates on the X axis in order (January before February before March...) (which should be pretty standard).
I can't seem to figure this out. My chart either sorts the legend alphabetically but puts the months in random order, or it puts the dates in order but doesn't sort the series.
Any thoughts? Thanks