graphing numbers in one column and numerous rows

johnny52

Active Member
Joined
Oct 13, 2006
Messages
325
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:
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
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
 

Forum statistics

Threads
1,141,160
Messages
5,704,649
Members
421,360
Latest member
Rhodia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top