View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

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