Plot graph lines for all values but show specific labels on horizontal axis

**deekon** · 10-18-2015, 03:07 PM

I've added some attachments below.

I have values on a chart. I want to show only January each year on the horizontal axis but at the same time plot all the values of the graph.

What I want to do is to plot and show ALL the graph points (in the .xlsx file attached) but not show all the labels. I want January for each year shows on the label.

The comparison is in the photo attached. I want to get the results on the right and not the one on the left.

I need help. Looking forward to someone to help real soon.

**MrShorty** · 10-19-2015, 12:51 AM

Your sample does not include a chart, so it is difficult to know what you have tried that has not worked. A line chart with a date axis should do what you want.

Perhaps the main problem is that your "dates" are not really dates but are text strings. You might first use the =DATEVALUE() function to convert these text strings to a date (https://support.office.com/en-us/art...3-b7471bbff252 ). Then, when you create the chart, Excel should automatically recognize that the horizontal axis should be treated as a date axis.