Make a Chart a link or Pop up in worksheet?

[Goose]

I am trying to make a chart a pop up or a link, I am needing to do multiple
charts on the same worksheet for each row, and this is the only way, I
believe the charts would be readable.

Also is there a way to copy the same date ranges for each row(similar to
copyin gthe same formula for each row).

 

[Jon Peltier]

You could do this with dynamic charts. Make one of each type of chart using dynamic ranges,
linked to a cell that holds the particular row number of interest. You can use some kind of
slider or other control to change the row number. There are a few techniques for this in my web
site:

http://peltiertech.com/Excel/Charts/Dynamics.html
http://peltiertech.com/Excel/Charts/ChartByControl.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______