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

excel vba courses london - excel charting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Excel charting

excel vba courses london - Excel charting

ResolvedVersion Standard

Steve has attended:
Excel Advanced course

Excel charting

Can the chart name be referred back to a cell ref so that if the cell ref changes the chart name follows suit?

RE: Excel charting

Steve

Afraid not.

david

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

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