View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default How should I do it?

try have Names to the left and value to right
then select Names and values and then make ur chart

C56=INDEX($A$56:$A$63,MATCH(D56,$B$56:$B$63,0))
D56=LARGE($B$56:$B$63,ROW()-55)
copy down

By the way if 2 names have same value then the first name showing twise

im trying to find a way to fix this