• 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.

Display the data based on more criteria in date range

V

Villalobos

Active Member
Hi,

I would like to extend the functionality of my dynamic chart, my target is that could be handle more criterias parallel and criterias will be in the drop down list (<- without helper colums) I mean that the unique criterias should be come directly from the table1 into the dropdown list.

Could somebody give me some advice how to do it?

Thank you the response!
 
Hi, Villalobos!
Your uploaded file seems to have an unrecoverable error, have you tried downloading it?
Regards!
 
@ myself..
I always thought, "Pivot Chart", why Microsoft, created this !!, but Now I realized, why Microsoft, created this !!
:)
 
@yourself
Hi, Debraj (ex-Roy)!
A doubt that you might be able to clarify... which is that rare font of your signature's 1st line?
Regards!
 
Hi ,

One way to get a unique list from a list with duplicates is to use a pivot table ; you can use a pivot table for each of the drop-downs , so that each drop-down displays only unique entries. The other method is to use formulae to derive the unique lists for plant , product and shift.

If these lists are not really dynamic as in the case of shift , where you are not likely to have too many shifts , and all the possibilities are known in advance , it is better to just have a static list entered for the drop-down. It is only when the list is long and dynamic ( which means that new entries can come into the list at any future time ) that you need to have a range which derives the unique entries , either by using formulae or by using a pivot table.

If you go for a pivot chart , as Deb has suggested , you don't need to do anything ; however , for the X-axis , choosing a period can be done using VBA ; if you want to do it manually , you have to select all the dates within the period from the row labels drop-down.

See your file.

Narayan
 

Attachments

Hi ,
or you can create a Helper Column.. in the table Like.. which can check date is between provided date, you can apply a filter in the Pivot Table, for the Helper Column as 1.
=(Táblázat1[[#This Row],[Date]]>=$I$2)*(Táblázat1[[#This Row],[Date]]<=$I$3)

˙7qɾɹıs @
˙˙ǝʇıs ɐ ɯoɹɟ pǝʇɐǝɹɔ ʇuoɟ ɐ sʇɐɥʇ
˙˙ʞɔǝu ɹnoʎ uɹnʇ uɐɔ noʎ ʍou ˙˙ʎuunɟ ooʇ ƃuıʞooן ǝɹɐ noʎ ˙˙ʎɐʍ ǝɥʇ ʎq
 
@Debraj (ex-Roy)
Hi, buddy!
I once found a page at a free website that via Unicode chars let me use reversed chars and a lot of things. At some time it was no longer available, and I forgot about it. And I did some stuff with Excel but I don't have a damn clue of where it might be that file, if it still exists.
Now about your funny advice I'm sorry to say that my neck has been always upward as my priority is never spill even a drop of Carlsberg. Besides I can easily read upside down and left to right, you don't? :eek:
So sorry to say but I don't look any funny at all (despite of the fact that I'm always funny ;)).
A secret and proprietary font, I understand.
Regards!
 
˙ʇɥƃᴉɹ oʇ ʇɟǝl uʍop ǝpᴉsdn ppolq-ɟlɐɥ ɹnoʎ uɐɥʇ ɹǝɔᴉu sʞool ʇᴉ pu∀ :SԀ
¡spɹɐƃǝɹ
): ʞɹoʍ oʇ ʇuɐʍ ʇ,upᴉp I puɐ ˙˙˙sᴉɥʇ ǝlƃooƃ ǝɯ ǝʞɐɯ noʎ oS
¡ʎnƃ ʎuunɟ 'ᴉH
(ʎoɹ-xǝ) ɾɐɹqǝp@
 
You must log in or register to reply here.
Back
Top