Help in Excel Chart

[JawaharPrem]

Hi All,

I worked report with dropdown box with index formula, and chart too, if i select P2P u can see the chart display, if u select Vrp or Fr the chart goes down, i need to show the chart value on upper, Please help on same. sample report enclosed.

thanks
Jawahar Prem

 

[Hui]

Jawahar

Add a few Named Formula and link the chart to them instead of duirectly to the data



Enjoy

 

[JawaharPrem]

Hi Sir,

its working file. Thanks for your Idea..