Firma Aktualności Produkty Projekty Teksty Muzeum Pobierz Kontakt Mapa RSS English
YAC Software Teksty VBA Usuwanie labelek małych wartości z wykresów PowerPointa Spelunka Trybików




Badania mediów

Badania rynku

Kwoty respondentów



YAC Data Language

Usuwanie labelek małych wartości z wykresów PowerPointa
Eee... jeszcze nie przetłumaczyłem...

Sprawdź wersję angielską.


Vascool napisał(a) dnia 2012-04-19 12:33:47
I have copied all 3 codes in PPT 2010 and i found Compile Error: ByRef argument type mismatch in below code

RemoveSmallPercentsFromChart chart

Please help
trybik napisał(a) dnia 2012-04-19 17:29:48
Hmm... I don't have PPT 2010 with me right now, but just try removing the 'As Chart' part from the declaration of the first sub.
zzGreg napisał(a) dnia 2013-03-04 15:02:18

If there were a way to rank everyone's VBA skills between 0 and 10, I think I would be around 0.3. I have only every used VBA in Excel, and in less than 2 minutes, I was able to remove a whole bunch of absolutely useless "0%" data labels from a presentation, with minimal modification to the code that you posted (yeah, I changed 1 character).

Thanks for sharing the code and also thank you for commenting it, so that even beginners like me can easily understand it!!!
Joy napisał(a) dnia 2013-04-01 02:50:40
hi, I'm interested in doing this exact same thing except on Excel (so that I can paste my chart as an image on PPT). I have tried modifying this code for excel but have been unable to do it. Do you have a similar version of it for excel?
trybik napisał(a) dnia 2013-07-02 08:50:04
The Excel version can be found here.
Yatin napisał(a) dnia 2013-07-02 16:05:35
Hi! Thank you so much for the code. It is very helpful. Just wanted to check about another thing related to this -
Let's say there is a data point on the bar chart whose data value is 4%. Now using this code, I have been able to hide the data value of 4%, but now I would also want to hide the data point itself on the chart. This is primarily because I don't want my audience to even look at the data point whose value has been intentionally hidden.
Would request you to please do let me know about the solution to this problem.
Thanks once again!
Yatin napisał(a) dnia 2013-07-02 16:13:55
Hi! Just adding to my point -
I want to remove only those data points whose all the values in the chart are 4% or less.
More clarification: Just like the way in the bar chart shown on this page, Brand 8 has all the values in the bar that are less than 5%, I would want to eliminate/hide only such cases. Not the ones like Brand 9, where one of the values is still more than 5%.
So, I would want to hide the data point of Brand 8 from the graph (both data point as well as the data values on the bar).
Tejas napisał(a) dnia 2014-02-18 14:41:39
This is awesome macro. Can you please help to remove value labels less than 5% only from Stacked Column charts.
Rohan Khole napisał(a) dnia 2021-06-05 18:58:54
Thanks for the code, but I have one issue, now I want this macro to run in the active presentation (i.e. I want this macro to be run in a different file or template) but not in the macro file, How can we do that? - Please help me on this
mckushak napisał(a) dnia 2021-09-04 12:48:41
Hi, help me please. How to make the macro select 5% of the value but not in the charts with relative values. Namely in diagrams with absolutes. The macro independently calculates the amount for each column and calculates the share of the amount, and eliminates those that are less than 5% of the amount


Dodaj komentarz (pola z gwiazdką są obowiązkowe)
Imię / ksywa *
Mail (pozostanie ukryty) *
Twoja strona
Komentarz (bez tagów) *
Wpisz tekst wyświetlony poniżej *




Podobne strony

Usuwanie labelek małych wartości z wykresów Excela

Otwórz wszystkie i połącz