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?
szadrogaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtCommented:
If the categories are actual dates (e.g. October 1, 2015), you can format it to show just the month using Custom number format mmm. Your chart will then show the month abbreviations in their correct order.
0
byundtCommented:
You can format either the source data or the chart category axis with the Custom number format mmm to get Jan, Feb, Mar, Apr etc. The attached workbook shows both approaches.
LineChartMonthAbbreviationsQ2873697.xlsx
0
szadrogaAuthor Commented:
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.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

szadrogaAuthor Commented:
sample file attached
sample.xlsx
0
byundtCommented:
It is best to convert text into dates at the source. In the case of this workbook, the source must have been on another workbook, because the chart makes no reference to cell addresses as the source of the dates. Making matters worse, this workbook uses PivotCharts, so I can't just edit the series formula.

To convert text that looks like dates into real dates, here are two tricks:
1. Copy a blank cell
2. Select the cells to be converted, then open the Home....Paste Special menu item and click the arrow at bottom right corner
3. On the resulting dialog, click Add and then OK
4. The dates should now look like numbers--but you can format them as dates using teh Custom number format mmm

Alternatively, use the Data...Text to Columns menu item
1. Select the cells to be converted (must be in a single column)
2. Open the Data...Text to Columns menu item
3. Choose Delimited in the first step of the wizard. Then click Next.
4. Don't specify any delimiters in the second step of the wizard. Then click Next.
5. In the third step of the wizard, specify Dates as the data type, then choose their format in the source text (e.g. DMY or MDY)
6. Click Finish
7. Format the cells using the Custom number format mmm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
szadrogaAuthor Commented:
the data is coming from an Access db.  Ill have to look into the source datatypes.  thx.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.