How do I make a number line in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a number line in Excel 2007 that takes a number from a
previous calculation and plots it on a one axis numbe line. For example, the
number 18.6 is calculated and I want it plotted on a line with one end at
16.3 and the other at 25.5. Any ideas?
 
If I understand correctly:
In A1 enter 18.6
In A2 enter =D5 (where D5 is the place where the calculation result appears)
In A2 enter 25
In B1, B2 and B3 enter 1
Make an XY chart from A1:B3
Format:set Min and Max on x-axis, remove gridlines, both axes, plot area;
etc
Happy to answer more questions
best wishes
 
Back
Top