How to use Scroll bar in Excel Column/Bar chart

[Palanivel]

How to control the display of long column chart i.e., 30 month planning (target & Achieved). Pls discribe the current value, minimum value, maximum value, Incremental change, Page Change, cell link.

 

[Hui]

Palanivel

Welcome to the Chandoo.org Forums


You use scroll bars to change variables in Named or Normal Ranges

to change the data that the chart is able to use

That is either the size or location of the ranges

Have a read of http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

For some ideas