Graphics in Excel ('03) 3

[pruleone]

Hy,

can anybody say, is it possible to make graphics come up only when one certain cell is filled up?

It would be like if argument to graphics - ex. if cell A2="YES", then graphics will appare. If A2="" or "NO", then graphics woun't appare.

 

[GlennUK]

Have a look at this:

http://www.ozgrid.com/forum/showthread.php?t=62575

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[pruleone]

Ok,

that sloutions can help me somehow.
Thank you

 

[pruleone]

I was wrong.
That info from that link dosen't help me.

Problem is that, this idea takes picture and will show or hide that picture. That means that it will show me picture from that time, when I did take it.

But graphics will change when I change some input information.

 

[GlennUK]

I'd say that it does exactly what you need.

Maybe I'm misunderstanding your requirement. Can you explain, in detail, what you want to do? What graphics are you talking about?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Gavona]

Glenn: Great technique... now I just need to think of an application for it!

pruleone: the technique will show a picture of a range from the sheet you created with the graphics on. The range is varied by changing the value A1.
Using the example - Say you want a blank picture when A1 has a value of "Apple": simply delete the picture of the apple on the new sheet.


Gavin

 

[pruleone]

I did it again and then did it work

Thank you!

 

[pruleone]

I need to bring this theame up again.

I got a problem - when I use print preview button then original chart will change!
Plot are will change, it will go smaller. I need to go and manually make it normal again.

Can anybody give any idea why excel is do like this?

 

[SkipVought]

Well...

a pair might get my attention!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

dressed, or undressed?

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

 

[fumei]

And a star to Glenn for an interesting link. I am not sure when I could possibly use it, but I thought it was kind of cool, and maybe at some point I will find a use for it.

"A little piece of heaven
without that awkward dying part."

advertisment for Reese's Peanut Butter Cups (a chocolate/peanut butter confection)

Gerry

 

[Kurupt55]

Thanks glenn, im sure that will come in handy, 1 more star for you

Impossible is Nothing