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
:)
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...
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...
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
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...
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:
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
@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 ...
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 :)
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:
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 :)