Excel 2010: Select / Reselect Data Source Of Chart

Excel 2010 provides a simple way to select the data source of charts and graphs, so that the entire table's values can be easily plotted. However, once the chart is created, one may need to change the chart ranges by manually tweaking the values. If you want to re-select the chart source data, like you did  while creating the chart, Excel 2010 offers you one click option. The Select Data option is included in the Design chart tab, which can be used after selecting the chart area. Once the tab appears on the ribbon, just click Select Data option from Data group to bring up Souce Data Source dialog to modify the data range by defining the columns and rows range. You can easily select the data source using the mouse, or manually enter the fields that you wish to include. It lets you switch row/column between original data source and imported data source, so that you can easily include the columns/rows you want to show in your chart, and remove the unnecessary ones. In addition, you can also view the hidden and empty cells and choose to show empty cells as gaps or zero on the chart. Read More

Change Chart Type In Excel 2010

Excel 2010 along with various kind of charts comes with multitude of options and tools to customize charts in a way you want. If you need to try out any other type of chart than one which you’ve already created, it lets you  do it easily. Lets see how to change the chart type. Read More

Excel 2010: Add/Change Chart’s Gridlines

You can show either Major or Minor or both types of Gridlines on a chart in Excel 2010. These three types of grid lines assist in scaling the chart against set parameters. If you’ve created one huge chart, you may need to insert gridlines for correctly measure every data point with it. To do so, select the chart and navigate to Chart Tools Layout tab, in Gridlines pull-down menu, from Primary Horizontal Gridlines options, select a desired type which you wan to insert. Read More

Record & Save Event Logs With Anylog

AnyLog is a tool for users who want to log an event but don’t want to publish it on the web. Personally, I would rather use Windows Live Writer for this purpose but not everyone wants to use it or feels comfortable using it. Users who save their important events on notepad and have cluttered desktop can consider using AnyLog.

Read More

IP Tray: Display System Hostname And IP Address

If you are working in such type of network envoirnment where the IP assignment is set to dynamic, then IP Tray can be useful for you. It sits in the system tray and upon mouse hover, it displays the current IP address of your system along with the hostname. You can also copy the IP address information to the clipboard. This can be useful for those who switch on their computer only to find that their IP address has changed. We know that constant changing of IP addresses can be a headache and frustration that we all have to deal with. If you are at home, then it can be solved by changing IP assignment from dynamic to static. But if you are in a work environment, like large enterprise companies, then this nifty little utility will come very handy.

Read More

Change Orientation Of Excel 2010 Spreadsheet

In contrast to previous versions of Excel, Excel 2010 includes a slew of features to quickly manage the page layout and cell spacing including both row and fields. Whether you want to set the page size, change row height/width, tweak default column width or adjust page margins, it provides all frequently used page layout settings on the ribbon. Like Word and PowerPoint, Excel 2010 page orientation is also set to Portrait, by default, but you can easily switch to Landscape according to your page print requirements. Along with orientation, you can also set the page size, as it offers a number of page size presets including Letter, Tabloid, Legal, A3, A4, B4, B5 and more. The portrait orientation is ideal of long data sets, which include only a few columns, however, if you're working on a data set that is spread across the screen, you should choose Landscape orientation to take print out of all required fields. Read More