microsoft excel training class - excel

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

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

microsoft excel training class - Excel

resolvedResolved · Low Priority · Version Standard

Elizabeth has attended:
Excel Introduction course
Excel Intermediate course

Excel

Can I create a pie chart and a line graph in the same chart?

RE: Excel

That's a combination chart.

1) Plot a line chart with all the data.
2) On the line chart, click on the pie chart series data and change the chart type to Pie.

See that works.

Katie


 

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.09 secs.