Excel Expert page contents

XLXpart

Microsoft Excel is one of the Best application provided within Msoffice suite. Excel is very popular software among Corporate Sector. We have gained some really fantastic experience. Believe us it is very wonderful application and you will really enjoy using it. This blog is trying to convey some of its Excel's Dynamic Functions, Versatile Functionality, Flexibilities and some fun tricks. We shall also try to resolve your queries.

Search Here

Loading

11/25/09

Dancing Chart

Ycan make some fun with Chart using Rand or randbetween (only for 2007 or later versions) in excel.
enter the formula in A1
=rand()
or
=randbetween(1,10)
copy the cell and paste it to a1 to j10
select the same range
and press F11
A new sheet with chart is created.
now keep holding F9 key and see the changes.
now change different chart types and colors and Enjoy.

Tip: Short Keys
F11 : Creates a new Sheet with Chart for selected Range
F9 : Re-calculats the entire sheet.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)