Showing posts with label hp compaq nc8400 keyboard. Show all posts
Showing posts with label hp compaq nc8400 keyboard. Show all posts

Thursday, August 11, 2011

Improving The Appearance Of Charts In Excel

There are lots of reasons that people use hp pavilion dv7-3079wm keyboard, hp pavilion dv7-3067cl keyboard Microsoft Excel. However, these reasons fall into three basic categories; storing data, analysing data and displaying data. Often a single spreadsheet will be used for all three, and it is the display of data that forms the basis for this article.

If you’ve ever prepared a presentation of figures in Powerpoint, you will certainly have found yourself borrowing charts from Excel. It is often thought these charts don’t have to be as visually appealing as the rest of the presentation. That’s simply an excuse used by people who don’t understand the full range of charting options in Excel.

First things first though. If you’ve got a bar chart that makes your point, don’t turn it into a bubble chart just to be different. Personally, I can say I’ve never used Excel’s bubble chart option and will unashamedly say that I’m not entirely sure what a bubble chart is. It does look nice, but it detracts from the graphic’s underlying meaning. So the lesson is that improving the appearance of a chart does not mean changing its form.

The second question is what you are trying to achieve in re-formatting a chart. Generally you wish to draw a viewer’s attention to a trend, and remove anything that may distract them. That means your chart’s formatting should be consistent with its surroundings. That means matching fonts, and it means matching colors. The key fonts to match are on the axes, the legend and, if present, the chart title. Colors will mainly hp compaq nc8400 keyboard, hp compaq nc8430 keyboard feature in the chart area itself though, unless it is being inserted on a dark background, I would always recommend making your Excel charts transparent.

Unfortunately every feature of a chart needs selecting separately. This can normally be achieved by right-clicking on the label you want and selecting the relevant Format option. If you cannot work out how to change an item’s properties, you can always consult Excel help by pressing F1.

The other way to draw people’s attention to your data is to make your data big. As long as your chart fits into its allotted space, the bigger the better. The first step then is to re-size the chart by selecting and dragging the corner until it fills the space available. However, that is not the only step.

Earlier I referred to your chart title. Take another look. Does it need to be there? If your axes are Month and Payroll Expenditure then what is your title adding? Probably very little. So you can delete it. What about the legend? You’ve only got one line. That can go as well.

Once you’ve removed unnecessary peripherals, you have to get a bit smarter. This may involve reducing font sizes or the room taken up by axes labels. If your y-axis is recording millions, does it need all the 0s on the end? If not, you should change your source data to a new column that quotes figures in millions. Not only does this allow you to expand the main chart area, it also simplifies the labels. That means less distraction for the reader and gives them a much higher chance of interpreting the data correctly.

It will only take you a few minutes to improve your Excel charts and, in the context of all the other work you will do, it is well worth doing hp probook 4510s keyboard, hp probook 4710s keyboard. The only reason people don’t is that they do not know what they are setting out to achieve. As long as you remember you are trying to be one of your audience, and not an Excel expert, you won’t go far wrong.

Paste Special In Microsoft Excel

Copy and paste. In Windows, there are hp pavilion dv7-3065dx keyboard, hp pavilion dv7-3085dx keyboard very few functions that everyone will use, but the ability to copy data in one place, and put it in another is considered to be one of the most basic IT skills. Even the keyboard shortcuts (Ctrl+C, Ctrl+V) are known by office workers all across the world.

On the internet, you might copy a link into your web browser. In a presentation, you may copy an image. In both cases, you don’t mind copying everything across to the destination. Unfortunately, if you are developing a spreadsheet in Microsoft Excel, it isn’t so simple.

In Word, the natural unit to copy is exactly that; a word. Due to the layout of a spreadsheet, the natural unit is not a number, but instead it is a complete cell. So instead of copying a value, you are copying a cell, complete with all its formatting and formulas. As Excel formulas transpose from one location to another, this allows you to copy a function across many rows of a spreadsheet. Even Excel experts benefit from the speed at which you can edit a spreadsheet. However, it can also become a great source of frustration to the beginner.

Imagine you’ve built a table and spent a hp compaq nc8400 keyboard, hp compaq nc8430 keyboard decent period of time applying borders. The data looks fantastic and can be inserted into Powerpoint. Next month the data has changed and you wish to copy it in from another source. If you use a basic Copy and Paste, you lose the borders. You may also lose the font, you can lose the color, you can even lose the text alignment. The whole reason for pasting data is that it saves time and it could now end up costing you time.

The solution is to use the Paste Special function. When you right-click on a destination within Excel, you will this option appear on the dropdown menu. You will then be confronted with a number of additional options. Let’s say you want to copy just the values from source to destination. In that case, you can select the Values option, hit OK, and none of the formatting will change.

Pasting values also has the effect of discarding any associated formulas. Therefore it is often essential to paste special as values when copying calculated data from one spreadsheet to another. Otherwise Excel will attempt to link the two spreadsheets which is often highly undesirable as it can throw up a bewildering array of messages when opening the file.

Sometimes you only want to copy the hp pavilion dv7-4000 keyboard, hp pavilion dv7-4100 keyboard formulas. This is the case if you are trying to apply formulas down the length of a table but e.g. the first line has a thick top border. Actually, the All except Borders option would do the job perfectly adequately if not better. All the Paste Special descriptions should be fairly self-evident and it’s worth experimenting each and every time you indulge in spreadsheet development.

Below the main options in Paste Special are a number of Operations. These allow you to add, subtract, multiply or divide all your entries by the same number. A common use arises when you open a text document that contains numbers. Sometimes Microsoft Excel will continue to treat numerical entries as text. This makes it impossible to manipulate the data. A nice trick is to enter in a blank cell, copy it, and multiply all the text-formatted cells by it. Excel will work out they are numbers whilst leaving the data unchanged.

Paste Special is one of Excel’s most important functions. In Office 2010, Microsoft have decided it deserves even greater prominence. Now when you copy data and right-click on a destination, a number of different paste options are automatically dell xps m1720 keyboard, dell xps m1730 keyboard displayed. It’s testimony to the fact that Paste Special is so ubiquitous that certain options are now considered almost as common as the traditional Paste.