Make a Chart a link or Pop up in worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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/
_______
 
Back
Top