asked on

Excel formatting x-axis - not all fields/categories

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?

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

szadroga

ASKER

I believe my issue is that the source data datatype is text. I tried unchecking the "linked to data source" box and setting the values as a date or number but still no luck. I have attached the file...does this help? Ideally, i would like just to have May, June, July...Oct along the axis.

szadroga

ASKER

sample file attached
sample.xlsx

ASKER CERTIFIED SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

szadroga

ASKER

the data is coming from an Access db. Ill have to look into the source datatypes. thx.