If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
i have an excel chart, a scatter diagram, which is working perfectly fine as
it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible |
#2
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
Hi ace,
i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible One way to do it is found here http://www.edferrero.com/ExcelCharts...2/Default.aspx Look for 'Chart Selector' - page 2 at the moment I think. Ed Ferrero www.edferrero.com |
#3
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
I need this answer too.... Ufff doesn't look easy to find a solution!
"ace" wrote: i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible |
#4
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
Ed,
Thank you for the reply. That is exactly what I am looking for, but my experience in VBA coding is minimal. How to go about it. Thanks Again, I genuinely appreciate it, Ace "Dan Tabla" wrote: I need this answer too.... Ufff doesn't look easy to find a solution! "ace" wrote: i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible |
#5
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
Guys ...Ed solution is magic.... God bless you ED!
"ace" wrote: i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible |
#6
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
Hi ace,
Thank you for the reply. That is exactly what I am looking for, but my experience in VBA coding is minimal. How to go about it. The sample is set up so that you should not need much VBA experience to adapt it to your needs. Replace the data with your own. Colour the cell background in column A to add more series. When a chart is shown, you can edit the chart colours, change markers, change the chart type - the code will work, just don't change the series range. Save often. If it breaks, download the sample again. Use {Alt}-{F11} to see and change the code. It is commented and should be easy to understand. You can always ask here if there are things you do not understand. You do not need to change the code to use the sample. Ed Ferrero www.edferrero.com |
#7
|
|||
|
|||
Excel charts to appear once i mouse over a certain cell???
Ed -
Thanks for the reply. It worked just fine. I truly appreciate this help. Thanks again, Ace "Dan Tabla" wrote: Guys ...Ed solution is magic.... God bless you ED! "ace" wrote: i have an excel chart, a scatter diagram, which is working perfectly fine as it is. I just want to know if there is any way in which I can put this chart in a comment or click a button which will display the chart and ensure that the chart gets updated as the input values change??? Is this possible |
Thread Tools | |
Display Modes | |
|
|