start date and end date (mnth&year) in combo box

[Former Member]

Hi All,

I have requirement user select start date ( in formart sep-09) and end date (they can select any mnth&year ) from combo box i need to display months in column chart based on dynamic selection from start date(mmm-yy) and end date (mmm-yy) how i can impliment logic in excel and mapping months with lables(x-axis) dynamic selection from combobox.

rewarads for issue.

Thanks,

[former_member212706 · Accepted solution]

Hi

Using combo boxes save the start date and end date in 2 two different cells. Say for example Start date at G6 and End Date at H6.

Choose a new row , say row 9, and copy the start date to one of the columns(B9). From the following cells in the row use the following formula.

=IF(A9="","",(IF(DATE(YEAR(A9),MONTH(A9),DAY(A9))>=DATE(YEAR($H$6),MONTH($H$6),DAY($H$6)),"",DATE(YEAR(A9),MONTH(A9)+1,1))))

Hope it helps.

Thanks,

Rajesh.

Please provide points to answers if you find them helpful

Edited by: Rajesh Jeyaram Raja on Nov 19, 2011 9:14 AM

Edited by: Rajesh Jeyaram Raja on Nov 19, 2011 9:54 AM

[Former Member · Accepted solution]

Hi Rajesh,

Thanks for your answer,but how i can map those months with column chart labels dynamically.

[Former Member]

Hi Sankar,

I guess you should create one more Connection/Query except then your to and from date. this new connection should have filter of type value range and your reqd measures & dimensions, now map your query prompt to the destination cells of your TO & From date combo boxes. I hope you will get your reqd output, map this to your chart and the values will be always dynamic as the output will always be filtered by prompts.

HTH

Neeraj..