Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
Hello,
Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
You cannot edit the text in these popups ("chart tips"). You can add a text
box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. 774-275-0064 208-485-0691 fax http://PeltierTech.com/ _______ "Refresher" wrote in message ... Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
Thanks a lot for the reply Jon.
I need to do this in source code. Basically, I am dynamically generating charts using the .NET -- Excel COM APIs based upon data from a SQL database. Will Tushar's utility allow me to call it from source code? Thanks. "Jon Peltier" wrote: You cannot edit the text in these popups ("chart tips"). You can add a text box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. 774-275-0064 208-485-0691 fax http://PeltierTech.com/ _______ "Refresher" wrote in message ... Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
I do not think Tushar's code has the broad capabilities you need.
Do you need something to pop up when the cursor moves over a chart element? Could you back up the functionality until all you require is a static data label or text box? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Refresher" wrote in message ... Thanks a lot for the reply Jon. I need to do this in source code. Basically, I am dynamically generating charts using the .NET -- Excel COM APIs based upon data from a SQL database. Will Tushar's utility allow me to call it from source code? Thanks. "Jon Peltier" wrote: You cannot edit the text in these popups ("chart tips"). You can add a text box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. 774-275-0064 208-485-0691 fax http://PeltierTech.com/ _______ "Refresher" wrote in message ... Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
Thanks again for taking the time to reply.
Let me give you an example scenario. Currently we have three primary components to an Excel page that contains a chart: 1. The Chart Title 2. A Text Box with additional information about the chart in it 3. The Chart. Lately though the text box (2) has become very unwieldly with data. So much so that many times it is so large that it squishes the chart very small. What we want to do is remove that text box and basically have that information stored somewhere such that when a user hovers or clicks somewhere on the chart (maybe it is a specific place on the chart or something), that information shows up in some sort of pop up way or dynamic text box or something. We don't want to have to put this text box information on another Excel page -- we want it all contained on the same page. Make sense? Thanks. "Jon Peltier" wrote: I do not think Tushar's code has the broad capabilities you need. Do you need something to pop up when the cursor moves over a chart element? Could you back up the functionality until all you require is a static data label or text box? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Refresher" wrote in message ... Thanks a lot for the reply Jon. I need to do this in source code. Basically, I am dynamically generating charts using the .NET -- Excel COM APIs based upon data from a SQL database. Will Tushar's utility allow me to call it from source code? Thanks. "Jon Peltier" wrote: You cannot edit the text in these popups ("chart tips"). You can add a text box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. 774-275-0064 208-485-0691 fax http://PeltierTech.com/ _______ "Refresher" wrote in message ... Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Embedding an annotation or a comment to a chart in Excel 2007
Something easy you could do is place the chart and textbox on the sheet,
with the textbox in front of the chart. Put a smaller textbox or shape that shows a simple "?" or "Chart Info". Assign a macro to this small shape that makes the large textbox visible, and assign a macro to the large shape that makes the large shape invisible. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Refresher" wrote in message ... Thanks again for taking the time to reply. Let me give you an example scenario. Currently we have three primary components to an Excel page that contains a chart: 1. The Chart Title 2. A Text Box with additional information about the chart in it 3. The Chart. Lately though the text box (2) has become very unwieldly with data. So much so that many times it is so large that it squishes the chart very small. What we want to do is remove that text box and basically have that information stored somewhere such that when a user hovers or clicks somewhere on the chart (maybe it is a specific place on the chart or something), that information shows up in some sort of pop up way or dynamic text box or something. We don't want to have to put this text box information on another Excel page -- we want it all contained on the same page. Make sense? Thanks. "Jon Peltier" wrote: I do not think Tushar's code has the broad capabilities you need. Do you need something to pop up when the cursor moves over a chart element? Could you back up the functionality until all you require is a static data label or text box? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Refresher" wrote in message ... Thanks a lot for the reply Jon. I need to do this in source code. Basically, I am dynamically generating charts using the .NET -- Excel COM APIs based upon data from a SQL database. Will Tushar's utility allow me to call it from source code? Thanks. "Jon Peltier" wrote: You cannot edit the text in these popups ("chart tips"). You can add a text box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. 774-275-0064 208-485-0691 fax http://PeltierTech.com/ _______ "Refresher" wrote in message ... Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
embedding pictures in a comment box | Excel Discussion (Misc queries) | |||
Embedding pictures on data points of a chart | Charts and Charting in Excel | |||
How do I add annotation to a graph | Excel Discussion (Misc queries) | |||
How to resize a comment box, by embedding code into a function? | Excel Worksheet Functions |