Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Get Label formula with get.formula(selection()) in XL-2007
Dear group,
in XL-2003 I can get a label formula with get.formula(selection()), when selection is a datalabel. Trying this in XL-2007, I get a type.mismatch. Any good ideas about this? Thanks, Holger. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Get Label formula with get.formula(selection()) in XL-2007
Holger -
This is a known bug in Excel 2007. This is also broken for the chart title, and I suspect other chart text elements are also broken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... Dear group, in XL-2003 I can get a label formula with get.formula(selection()), when selection is a datalabel. Trying this in XL-2007, I get a type.mismatch. Any good ideas about this? Thanks, Holger. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieving linked label formula with VBA | Charts and Charting in Excel | |||
How do I use a worksheet label to create a formula in Excel 2007? | Excel Discussion (Misc queries) | |||
How do I use a worksheet label to create a formula in Excel 2007? | Excel Discussion (Misc queries) | |||
Data Label Value in Formula? | Charts and Charting in Excel | |||
Formula looks like a label | Excel Worksheet Functions |