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

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
0
kensy11
Asked:
kensy11
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

format the horizontal axis and set the maximum value to 8

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
byundtCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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