Hi, i want to link a chart with another worksheet in the sme workbook
as the chart.

On the sheet 'graphique' i have my chart.
On the sheet 'OEE' i have something like 3000 column. I want something
like; everytime the person click on the update_chart button the range
for the graph selected value use the next column.
ie:

may 10 may17 may 24 ......
prod1 25% 30% 17%
prod2 66% 53% 87%

My chart is like that:
may 10

100% |
80% |
60% |
40% | _____
20% |_____ | |
0% | | | |
|----------------------
prod 1 prod 2 ............i have 15 prod.

____________________
|update_chart_button |
|____________________|


so everytime the person click the update chart button it updates the
graph with new data from the new date. ie: clicking on the button with
go select data of may 17. clicking again will select may 24 data. and
so on....i've got 3000 columns at least. i dont know if somebody can
help me out. Can we do something with selecting the date (inserting
the date) and it will go find the right column and use the value of
the column.thx (by the way i'm new to VBA but i've been using macro
for a long time)