• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • Last Modified:

excel x-axis label not showing

I am trying to display the month on the x-axis. But it does not show for some reason (see pic).

pic
0
leblanc
Asked:
leblanc
  • 6
  • 5
  • 2
  • +2
2 Solutions
 
Rgonzo1971Commented:
HI,

Could you send a dummy?

Regards
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi,

perhaps you need to turn the label display on?

from the Chart Tools DESIGN ribbon:

AddChartElement > AxisTitles > PrimaryHorizontal

Show Axis Titles on Excel Chart
have a day that matters,
crystal
0
 
Mike in ITIT System AdministratorCommented:
Looks to me like the label is showing in your included image. If it is showing then where is the problem? Is it showing something other than what you are expecting?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Karen FalandaysTraining SpecialistCommented:
When you select the data for the graph, highlight all, including the labels
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi,

select A1:C5

press the Alt-F11 key

this will make an embedded chart with the selected data.  It will be a column chart and then you can change the chart type to line which is what I am assuming you want since nothing is showing*

*the Y-Axis axis range is too small to show any of the data.

It also looks like column C did not get on the chart.

have an awesome day,
crystal
0
 
leblancAccountingAuthor Commented:
Crystal,
Sorry the column was not selected. Now when I changed the chart type with the dots, how do I keep my month label. thanks
pic
0
 
Mike in ITIT System AdministratorCommented:
Could you explain in more detail what you want the whole chart to show?

Right now in your most recent comment, the picture shows that there are 2 data points on the x-axis and that each of the 4 categories has a number for each data point. Also, is this a scatter graph? or are you looking to make a line graph, bar graph, scatter graph?
0
 
leblancAccountingAuthor Commented:
I want my y-axis to show the percentage and my x-axis shows the month (nov & dec). Also, instead of a line, I'd like to just have the dots. I think that would be he scattered chart. Correct?
0
 
Mike in ITIT System AdministratorCommented:
Okay, so I think you are looking for something like this:
Chart.PNGThis is a "Box and Whisker" chart.
I show the config box for selecting the data.
What I did:
  • I selected the whole data set first
  • then went and inserted a chart.
  • I had to tell it what to use as the Horizontal Axis Labels, but otherwise, it set it up correctly with the Month on the bottom.
Axis-Labels.PNG
Here is an example of the Series:
Edit-Series.PNG
0
 
leblancAccountingAuthor Commented:
Mike,
That is exactly what I am looking for. Where is the Box & Whisker chart? I don't see it in my chart types. Thx
0
 
Mike in ITIT System AdministratorCommented:
It is in my selection of charts. When I select the Inert Recommended Charts I switch tabs to the "All Charts" tab and then select the Box and Whiskers:
BoxAndWhisker.PNG
0
 
leblancAccountingAuthor Commented:
I don't have that. Is that an add-on?

pic
0
 
Mike in ITIT System AdministratorCommented:
What version of Office do you have?
I'm using 2016

I have found this that might help. It's a description of how to manually create the box and whisker chart in Excel from 2013. It's long so I'm not going to summarize here unless it becomes necessary. I didn't write it.
0
 
leblancAccountingAuthor Commented:
I think it is in 2016. I need to create it in my 2013. Thanks
0
 
Mike in ITIT System AdministratorCommented:
Did you try the example in the link I provided? It is a lot of work but looked like it would work for you.
0
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 6
  • 5
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now