If I have a chart that its data source refers to a range, how to get a lot of
charts that refer to different cells and display different values? just like
dragging and dropping cell to get many cells that contain auto-increased
formula.

Please download AddinTools Create from http://www.addintools.com

The add-in tool make you using formulas and cell references in Excel
objects: diagram, autoshape, wordart, and organization chart, to get hundreds
of these objects and charts, reports, tabs, cards, forms that displaying
different values in a minute!