I have an excel line chart with (2) fields / categories on the x axis field. One is a month name (Jan, feb, etc) and the other is month value (1, 2, etc). I had to do this in order to get the sorting to work, very frustrating. I also tried concatenating the fields but for 10-Oct if puts that first which is wrong.
So i am looking to format just the field month value to a white text font so it "disappears" from the chart. Can this be done?