Hello All !
I want to update in a chart through a button click.
The source file is update daily & I want to update the relevant chart automatically through a macro button so that only the fields are updated which has the data in them, no blanks data or empty cells should be updated.
Because if you link the chart with a huge range then its takes then values as zeros & look of the chart/scale is disturbed.
Secondly if anybody know how to change any chart through a macro click button to change the chart type from column to line to pareto to stack and etc.....
Waiting for the reply.
Bookmarks