How do I make a number line in Excel?

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign data series to primary axis 1
adding trendline to plots from multiple series 1
multiple series bar and line chart 2
How do I extend the X-axis in Excel2007 3
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
How to Plot This Data? 2
dual y-axis align grid, drop line to y axis, add-ins 1
How do I stop trendline from touching the y-axis? 7

Top