![]() |
#3
|
|||
|
|||
![]()
Thank you very much!
It is almost working. However I found a way in which power point charts are really misleading (attached file). As you can see your macro works great on second slide, but on first it is mislead. It's about legend order. On first slide it's "upside down" in excel meaning, on second one it's ok. On first slide it is counting the opposite way (it should left "e" which is 5th from the beggining, instead it does not delete "l" which is 5th but from the end). So to make it automatic, macro need to check the order. If the order is "upside down" it should take "upside down" legend entry and delete it ![]() Changing: Code:
If Not b_val Then ocht.Legend.LegendEntries(m).Delete Code:
If <Legend Enteries has appropriate order> Then If Not b_val Then ocht.Legend.LegendEntries(m).Delete Else If Not b_val Then ocht.Legend.LegendEntries(ocht.SeriesCollection.Count - m + 1).Delete End if Of course it is possible to change Legend into "under chart" in each before starting macro, but then on some macro should reverse it and on some not so it would be difficult this way ![]() |
Tags |
powerpoint macro |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
can power point LINK to embedded object in power point ? | johnseito | PowerPoint | 0 | 05-24-2014 04:31 AM |
![]() |
Paincho | PowerPoint | 1 | 06-27-2011 08:07 AM |
Microsoft Power Point 2004 to Office Power Point 2007 | chuff | PowerPoint | 0 | 03-20-2011 01:23 PM |
Power Point on the Web | Carthalion | PowerPoint | 0 | 03-03-2010 09:59 AM |
power point | ladonna12 | PowerPoint | 2 | 02-16-2009 09:34 AM |