ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I sort rows containing graphics? (https://www.excelbanter.com/excel-worksheet-functions/147137-how-do-i-sort-rows-containing-graphics.html)

Faetan

How do I sort rows containing graphics?
 
I'm having a hard time keeping graphics linked or embedded to their cells.
Even if I click the radio button 'move and size with cells,' the graphic
won't stay there when the rows are sorted. How do I get them to stick for
good?

Toppers

How do I sort rows containing graphics?
 
I don't believe you can. Perhaps you need to consider an alternative to radio
buttons if you really need a sort to include the radio button "status".

"Faetan" wrote:

I'm having a hard time keeping graphics linked or embedded to their cells.
Even if I click the radio button 'move and size with cells,' the graphic
won't stay there when the rows are sorted. How do I get them to stick for
good?


Faetan

How do I sort rows containing graphics?
 
I'm not trying to sort a radio button, I'm trying to sort the row containing
the graphic. Right now, the row moves, but the graphic doesn't.

"Toppers" wrote:

I don't believe you can. Perhaps you need to consider an alternative to radio
buttons if you really need a sort to include the radio button "status".

"Faetan" wrote:

I'm having a hard time keeping graphics linked or embedded to their cells.
Even if I click the radio button 'move and size with cells,' the graphic
won't stay there when the rows are sorted. How do I get them to stick for
good?


Toppers

How do I sort rows containing graphics?
 
The graphic won't move whatever you do but if it associated with a row, then
you need an alternative to act in the same way as your radio button..

"Faetan" wrote:

I'm not trying to sort a radio button, I'm trying to sort the row containing
the graphic. Right now, the row moves, but the graphic doesn't.

"Toppers" wrote:

I don't believe you can. Perhaps you need to consider an alternative to radio
buttons if you really need a sort to include the radio button "status".

"Faetan" wrote:

I'm having a hard time keeping graphics linked or embedded to their cells.
Even if I click the radio button 'move and size with cells,' the graphic
won't stay there when the rows are sorted. How do I get them to stick for
good?


Gord Dibben

How do I sort rows containing graphics?
 
See this google search result.

http://tinyurl.com/2jp2wq

And this one..........note Dave's comment about making sure the graphic does not
overlap rows.

http://tinyurl.com/3al8xw


Gord Dibben MS Excel MVP

On Tue, 19 Jun 2007 13:33:27 -0700, Faetan
wrote:

I'm having a hard time keeping graphics linked or embedded to their cells.
Even if I click the radio button 'move and size with cells,' the graphic
won't stay there when the rows are sorted. How do I get them to stick for
good?




All times are GMT +1. The time now is 11:45 PM.

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