excel microsoft training - excel charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Excel Charts

excel microsoft training - Excel Charts

resolvedResolved · Low Priority · Version Standard

Havva has attended:
Excel Intermediate course
Excel Advanced course

Excel Charts

Dealing with percentages in charts. Why are percentages x by 100.

RE: Excel Charts

Hi Havva,

Do you mean that every time you enter a number and set it as a percentage it comes out 100 times larger. For instance if you enter 10 and convert it to a percentage you end up with 1000%?

If so simply enter the value in to the cell as a decimal fraction. For example if you want 25% first type in 0.25 and then format as a percentage.

Regards

Stephen


 

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips


Server loaded in 0.08 secs.