special effects in charts

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: special effects in charts

  1. #1
    New Member
    Join Date
    Aug 2003
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default special effects in charts

     
    Hello, everybody
    I have a chart that represents a complicated equation, and a table that is the solution of another equation (this solution is just a point of coordinates x,y). I had to combine both in only one chart: the first one is always the same curve (absolutely no changes), and the point do change its position with input data. Now, I need to give this point some special effect; in fact, the suggestion was to make it flash every X seconds, and I thought to make it change its colour every X seconds too. Is it possible? If it is, how?

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    Dallas
    Posts
    366
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: special effects in charts

    Only thing I know of off the cuff is that you can change any point in an excel graph to a picture (button, graphic, Autoshape, etc), by copying what you'd like to use, selecting the point, and CNTRL+V pasting. This at least gives you the opportunity to customize the graph a bit more than the standard tools in the graph menu.

    Hope that helps
    - Thomas

  3. #3
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    11,007
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: special effects in charts

      
    Other than Thomas' idea, the only other items I can think of are (a) use error bars to create a vertical and a horizontal line from the special point to both axis, and (b) use VBA for special effects, though, IMO, it's not worth the effort.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com