graphing numbers in one column and numerous rows

johnny52

Active Member
Joined
Oct 13, 2006
Messages
318
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
Hi I'm using excel 2000 xp version...my question is how can I graph an existing column of numbers within my spreadsheet..like this
102
99
92
104
108
88

using no background charts....is this possible to move the number to the left if its lower and move it to the right within the cell if higher

Thanks everybody....love this site !!

Thnaks PGC...your solution worked !!!! Great !!!! :biggrin:
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi johnny52
Welcome to the board

Since your numbers go from 88 to 108 you can, for instance, write 1 space before the number for each unit over 80.

If your numbers are in A1:A6, write in B1

=REPT(" ",A1-80)&A1
Copy down till B6

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,111,597
Messages
5,541,160
Members
410,543
Latest member
ExcelGlenn
Top