Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
PowerPoint-tags in Excel
Hi folks who know the use of tags in PowerPoint,
I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
PowerPoint-tags in Excel
Brian -
I'm not too familiar with tags, except for being jealous that you guys got em and we ain't. I would follow the same scheme that you're describing. Don't delete the old chart until you know the new one has taken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message ... Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
PowerPoint-tags in Excel
Jon,
Thanks for the advice. Yes tags are wonderful. I've almost stopped using shape names in favor of tags which store two properties, a name and a value. And you can literally have thousands of them attached to a shape. It's sort of like have two XL columns to store variables in like Top 42 Brian Reilly, PowerPoint MVP On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier" wrote: Brian - I'm not too familiar with tags, except for being jealous that you guys got em and we ain't. I would follow the same scheme that you're describing. Don't delete the old chart until you know the new one has taken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message .. . Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
PowerPoint-tags in Excel
Do you still have these with the "new improved" Office 2007 shapes?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message ... Jon, Thanks for the advice. Yes tags are wonderful. I've almost stopped using shape names in favor of tags which store two properties, a name and a value. And you can literally have thousands of them attached to a shape. It's sort of like have two XL columns to store variables in like Top 42 Brian Reilly, PowerPoint MVP On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier" wrote: Brian - I'm not too familiar with tags, except for being jealous that you guys got em and we ain't. I would follow the same scheme that you're describing. Don't delete the old chart until you know the new one has taken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message . .. Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
PowerPoint-tags in Excel
Jon,
Yes, a shape is a shape even in Office 2007. Other stuff has changed (g) but they didn't delete any of the old stuff. Check out the PPTFAQ.com page and search on tags for more information. They are really good things to know about if you are coding in PPT. Brian Reilly, PowerPoint MVP On Thu, 13 Sep 2007 18:50:24 -0400, "Jon Peltier" wrote: Do you still have these with the "new improved" Office 2007 shapes? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message .. . Jon, Thanks for the advice. Yes tags are wonderful. I've almost stopped using shape names in favor of tags which store two properties, a name and a value. And you can literally have thousands of them attached to a shape. It's sort of like have two XL columns to store variables in like Top 42 Brian Reilly, PowerPoint MVP On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier" wrote: Brian - I'm not too familiar with tags, except for being jealous that you guys got em and we ain't. I would follow the same scheme that you're describing. Don't delete the old chart until you know the new one has taken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brian Reilly, MVP" wrote in message ... Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mappoint smart tags in excel - (not working) | Excel Discussion (Misc queries) | |||
editing music tags in excel | Excel Worksheet Functions | |||
How do I add smart tags to stock symbols in an Excel chart? | Excel Discussion (Misc queries) | |||
Excel to PDF w/ Data Tags | Excel Discussion (Misc queries) | |||
smart tags in Excel? | Excel Discussion (Misc queries) |