I want to produce a picture of a currency whose image size is proportional
to its data value. For example, based on $1,000, I'd like to create a
picture of a $500 data value that is one-half the size of a $1,000 reference
value. Can this be accomplished?

Thnax.

Hi,

You need to use the set the Stack to scale value on the Picture tab of
the Fill Effects dialog, which you can display by double clicking a bar
and pressing the Fill Effects button on the Patterns tab.

Jon Peltier has a page explaining it.
http://peltiertech.com/Excel/ChartsH...tomStacks.html

Cheers
Andy

Michael R. Bogdan wrote:
I want to produce a picture of a currency whose image size is proportional
to its data value. For example, based on $1,000, I'd like to create a
picture of a $500 data value that is one-half the size of a $1,000 reference
value. Can this be accomplished?

Thnax.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info