excel graph

hello,
i have some difficulties with excel graph , please look at the image and the excel file i have uploaded.

I want the graph to be end at the nummber 8 ,i have tried everything but couldn't get it right

Thank you
Copy-of-Les01-Grafieken-Reeks2-O.xlsx
remove.png
kensy11Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

format the horizontal axis and set the maximum value to 8

cheers, teylyn
0
 
kensy11Author Commented:
Thank  you, teylyn.  
Sorry i have one other question, why is there's a little green arrow next to my numbers  ?  is it an error ??

 
arrow.png
0
 
byundtConnect With a Mentor Commented:
The little green triangle indicates a possible formula error. Excel compares the formula to ones in adjacent cells. The green triangle appears it the cell formula is inconsistent in one of more ways. Most of the time you can ignore it.

If the green triangles bother you, uncheck the box for  "Enable background error checking"  in Tools...Options....Formulas

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

All Courses

From novice to tech pro — start learning today.