• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Dillina

    Lock the labels in a pie chart

    Guys....you are always impressively good. Luke, I'm still thinking of your intelligence for a "simple" but very smart solution. Vletm very good as always! Guido too, Hui .... all of the champions I love Excel and with you, even more and sorry for my bad english :)
  2. Dillina

    Lock the labels in a pie chart

    Vletm!!! :) What can I say? In Italy we said " La classe non è acqua " I believe that in English is "The class is not water", but I do not know if it makes sense :rolleyes: It means that your level is always very high. Your solution is also WONDERFUL that I will try immediately. Thank you so...
  3. Dillina

    Lock the labels in a pie chart

    What a BRILLIANT idea, Luke!!!! :eek: Me gusta muchisimo!!!! :) I try it immediately in my original file! Thank you very much!! :)
  4. Dillina

    Lock the labels in a pie chart

    Hello guys, I'm still here for your advice. :) This time I would like to know if there is the possibility of "blocking" the labels with the percentages in the chart. I have a hand (picture above the graph) :rolleyes: For the moment it is not dynamic and I have only entered January 2018, but in...
  5. Dillina

    How to arrange data correctly to create a Slicer and Timeline

    Hello Guido, thank for your attention :) Yes, it actually gives me an error when it can not find the data. Yesterday evening and today I worked a lot on my file and I think that for the moment I will use the solution of the post #5, even if it is not the best one. Thanks so much Dilly
  6. Dillina

    How to arrange data correctly to create a Slicer and Timeline

    Good morning guys, for the moment I invented (using the Macro recorder, because I don't Know VBA) choose the time frame and create a button that tells me in the graph the time I put in the macro. (I do not know how to insert the Tag for macros, for this reason I did not write it) Graphically...
  7. Dillina

    How to arrange data correctly to create a Slicer and Timeline

    I learned a nice thing with Radio Buttons today!! Thank to Guido and :awesome:!! ...and for the timelines is there a solution? Don't kill me, please! :oops:
  8. Dillina

    How to arrange data correctly to create a Slicer and Timeline

    Guido !!! :) But what a beautiful gift you made me for Easter !! :eek: Better than the egg !!! I love Excel and I love you !!!! :p Now I study and try to understand how you did that I do not know well these "wonderful" Radio Buttons. Grazie Kiss Dilly
  9. Dillina

    How to arrange data correctly to create a Slicer and Timeline

    Hello Guys and Happy Easter!! :) Sorry if the question is stupid but I'm only now beginning to study Tables Pivot, Slicers and Timelines. For many months I have not found the way (and I do not know if it's possible) to insert a Slicer into a dynamic chart (combined) like the one I posted here...
  10. Dillina

    Value disappeared when I use combined tables

    Good morning Guido and Happy Easter! :) My head is very hard to understand, but I know that I'm close and I know that in a week I'll tell myself ..... What a "idiot" I've been not to understand right away! I'm transforming my file with your advice where there are real data and I like it very...
  11. Dillina

    Value disappeared when I use combined tables

    Buongiorno Guido :) I must admit that it is very difficult for me to understand the mechanism. Maybe I miss some basic passage. :mad: But I can tell you that you're a genius because that's what I wanted. Let me test several times and I am sure that I will understand better what you have...
  12. Dillina

    Value disappeared when I use combined tables

    Hi Guido :) I have not forgotten about you ... Today I looked at the file ... I had very little time available (for work) I'm trying to understand but I must admit that I did not understand much, but I think it was because I did not have much time available. Tomorrow I will watch it with more...
  13. Dillina

    Value disappeared when I use combined tables

    Hi Guido :), I downloaded the file. Now it's me that I need time to understand it. Google translator will help me to translate the English of the DOC sheet better and my mind will have to understand the formulas well and if it is really the graph I was looking for a long time. Apparently it...
  14. Dillina

    Value disappeared when I use combined tables

    Dear Guido, Do not worry about the time. I will be very curious to see what you do, but above all to learn new things. I love graphics and this type of graphic for me is very, very important. I want to learn how to do it. Excel is like a drug....more you know it, more you pretend and more you...
  15. Dillina

    Value disappeared when I use combined tables

    Thanks Guido for your help and your patience. For two years I'm challenging Excel, when I knew only use the sum formula. :DD My problems are two: I do not know the pivots well, I do not speak English to explain how I would like to In this new file I inserted in the sheet "Chart no Pivot". This...
  16. Dillina

    Value disappeared when I use combined tables

    Actually Guido, I just realized that I have another problem :eek: Excel is full of surprises, especially for those who do not know it well and I apologize for this. The post was born to know why when I combined two tables did not appear to me this famous "product". But now I have seen that I...
  17. Dillina

    Value disappeared when I use combined tables

    Hi Guido ... I thought you were Italian !!!! : D 1: You said a great truth: "I believe you are trying to use a feature here of which you do not know the basics." 2: Power Pivot ???? Never use Power pivot. I do not have Power Pivot in Excel 2013.:eek: Is not possible use two simple pivot...
  18. Dillina

    Value disappeared when I use combined tables

    Hello Guido and thank you for your answer :) Sorry for my English. (I take this opportunity to congratulate you on the bike chart because it is wonderful and I love graphics.) For my file instead ... I do not understand why if I work only with a table, the value I want is present and in the...
  19. Dillina

    Value disappeared when I use combined tables

    Hello guys :) I have a problem with pivot tables, ONLY when I work with two combined tables. I do this: Sheet 1: I create a table Sheet 2: I create the second table Click in the second table, enter Pivot Table, put the flag in "Add this data in the Data Model" I call Table Pivot the 3 sheet: I...
  20. Dillina

    Gantt Chart with ScrollBar...Problem!

    @vletm sorry for waiting, but today full day ... WOW more and more beautiful this GANTT !!! : D I would need 48 hours ... not 24! I have to find the time to study this new Gantt ... it's very nice and professional !! You are very kind and sorry if I don't answer you in time ...
  21. Dillina

    Gantt Chart with ScrollBar...Problem!

    You're right ... want is power! Volere è potere...in italiano!! It's time that's missing ... everyone's problem. And I guarantee you that it's not an excuse. In the last two years I discovered Excel and I fell in love with the power that he has, but still nothing vba ... next step ... I promise :)
  22. Dillina

    Gantt Chart with ScrollBar...Problem!

    Fantastic Hui!!! Grazie mille!! :)
  23. Dillina

    Gantt Chart with ScrollBar...Problem!

    How did you do it? :eek: me and the vba we punch (i don't know if is correct to say) and the xslb extension is the first time in my life that I see it This evening I will try to understand it (now I can not) But it will very difficult for me to understand, I miss the basics of vba :oops:
  24. Dillina

    Gantt Chart with ScrollBar...Problem!

    WOW!! Che bello!!!! :) It's beautiful, give me time to watch it well !! Tonight I answer you calmly ... Thanks so much!!! L'italiano è perfetto!!! ;)
  25. Dillina

    Gantt Chart with ScrollBar...Problem!

    It's fantastic like all your solutions :) Only one thing ... every time I click on the scrollbar the data on the left "select" all .... Is it possible that this "selection" does not appear? Grazie :)
Back
Top