microsoft excel courses - Format chart

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Format chart

Ester has attended:
Excel Intermediate course

by - delegate Ester [1 post] (2007 Jun 28 Thu, 13:30) Reply

How to format the chart in one go?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Format chart

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 10:38) Reply

Hi Ester,

Thanks for the question.

If you use the Chart menu that appears when you are in a chart there are various different ways you can format your chart. You can change the titles to changing the font, everything is able to be formatted. When you say in one go, which bit did you have in mind.

Look forward to hearing from you

Tracy

· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Training Course
· Advanced Excel Training - takes you to the next level
· Prepare for your MOS Certification with MS Excel Courses
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips