Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphically display data on a number line
I want to graphically display a row of numerical data I've got in an Excel
worksheet on a number line instead of a chart. Is there a way of doing this in Excel or any other Office application? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphically display data on a number line
1) put the text in A1:A10
2) the x-values (for the number line) in B1:B10 3) In C1:C10 enter .5 4) Format the y-axis range 0 to 1; format x-axis to cross at 0.5 on y 4) Make an XY chart from B1:C10 5) Use Bovey labeller www.appspro.com to get the text as labels 6) format the chart, removing y-axis, plot area, etc; and make the vertical dimension small (may need to adjust the font sizes) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ChuckK" wrote in message ... I want to graphically display a row of numerical data I've got in an Excel worksheet on a number line instead of a chart. Is there a way of doing this in Excel or any other Office application? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter - failure to display ALL data down a column | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |