ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make a number line in Excel? (https://www.excelbanter.com/charts-charting-excel/132845-how-do-i-make-number-line-excel.html)

fairchildbrad

How do I make a number line in Excel?
 
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?

Bernard Liengme

How do I make a number line in Excel?
 
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"fairchildbrad" wrote in message
...
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?





All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com