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

excel training - graphs

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

excel training - Graphs

ResolvedVersion Standard

Sarah has attended:
Excel Advanced course

Graphs

how to show profit and expense per product on a graph with a line for profit and a line for expenditure to see how vary with increased sales

RE: graphs

Create a chart using the CHART WIZARD, and select the relevant data sources in the second step.

You might need to select the source data separately, so use the CTRL button to help you select it.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.