Dynamic Line Graph

[ajay_gajree]

Hello All,

I am making my first attempt at making a Dynamic Line Graph.

I have a simple set of data, Dates with the number of trades each day for a specific client. I would like to plot a line graph for the last 5 days, data will be added each business day.

I have got as far as naming the ranges and adding Drop Down Box,

Can someone point me in the next direction, I can not seem to link this drop down box to a chart.

Thanks in advance for your help

 

[Derek Brown]

Hello and welcome to The Board.
Jon Peltier's site contains many examples and ideas for charts. You may find that the section on 'Dynamic Charts' will help you with this problem.
http://peltiertech.com/Excel/Charts/ChartIndex.html

 

[ajay_gajree]

Thank you Derek,

Best regards

Ajay