Results 1 to 3 of 3

Excel 2007 : Dynamic graphic placement (chart or other)...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-09-2008
    Location
    Dallas
    MS-Off Ver
    2007
    Posts
    121

    Dynamic graphic placement (chart or other)...

    Not sure how to explain this; is there a way to do a formula (IFstatement, perhaps) such that based on the formula result, a graphic appears anchored to that cell (or not)?

    So if C1 were to equal 1, for example, a picture of an apple would appear in that cell?

    Or perhaps a way to add a graphic like that to a bar chart such that the bar doesn't fill up with the graphic (neither stacked nor stretched), but appears a single time at the 'top' of the graphic (eg: like a horserace or boatrace, such that a horse or a boat is at the 'top' of the bar, like where the data label would be)?

    Then as the underlying data changes, the graphic would 'move' to reflect it, but always at the same relative position (top of the bar)...

    Any thoughts? Thanks!!
    Last edited by jwhitwell; 05-25-2010 at 10:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1