Link spin button or scroll button to chart.

[Thainguyen]

So i have the template layout in the picture attached below. I would like to know how to link the Spin button to able to show month by month when i click on the spin button. Here is the formula i have so far, everything working fine except for the chart doesn't link to the spin button. Even though i have created the Name management.

E4 formula : ="Monthly "&E5&" - Audit Sheet Delivery"
data for eat month for LATE row:=IFERROR(VLOOKUP(G3,$A$4:$C$6000,2,FALSE)," ")
Same for On-Time:=IFERROR(VLOOKUP(G3,$A$4:$C$6000,3,FALSE)," ")
Spin button link to cell $E$5

I have created define name for each Month, Late and On-Time and linked it to the chart but it doesn't work. Please point out what i have to do in this case. Also, please show the code on here due to i am new to this. Thanks

2063

[Thainguyen]

0
down vote
accept

Thanks you all for your help. I did figure out one way to make it work for me. However, i will more than happy to learn new way or a better way to use spin button and scroll button to changing my chart.

Changes data layout table
Using index formula and vlookup (Cell F19, G19,H19) formula included in picture below)
Changes define name formula to pull data from Cell (Cell F19, G19,H19).
Now i can click on my spin button and the chart changing month by month for me.

It is working fine for me. But i love to learn more if anyone can show me a better way to do it. Please include pictures and formula in your answer. It will help me and other easy to follow it. Thanks2064