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
LVL 1
leblancAccountingAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

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
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
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 Office

From novice to tech pro — start learning today.