Graph Data Change

[Axe1302]

I have table in excel and I want it to change the graph data (date and Y axis) every time
I change the date range I will encode in input cell. After date range encoding, the data in the graph will need to change also. Pls. see attached file for my data and graph. This will be helpful if it will be solved as this is usually used in data retrieval and presentations. Pls. help.


thanks,
Axe1302

[adhawan06]

Hi Axe,

I can recall you data. :P

Here you go and refer to the attached file for your reference.

I have made the small changes in placement of Inputs for From & To (hope this will not make any prob)

What I did is defined the dynamic range for From & To criteria and then I considered the same for the dynamic Chart.

So Now if you select 2nd Apr in From & 7th Apr in To, the chart will updates only for the selected period. (Hope this will help you to meet your goal).

Let me know if you have any doubt.

Cheers!!!

Anil Dhawan

[Axe1302]

Hi Anil.

This is very helpful. Thank you very much.

thanks,
Axe1302

[adhawan06]

Hey Axe1302 - Glad it worked and thanks for adding feedback and Reputation.

Keep visiting here...