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

charts

ResolvedVersion 2003

Rachel has attended:
Excel Advanced course

Charts

Is it possible to use corporate colours in charts?

RE: Charts

Morning Rachel,

Yes is the answer, and you can even have logos in the backgrounds of your charts.

To change your corporate colours would depend on who wants them. If it is just for you then you will need to create a chart first and make the relevent changes to the coloured bars. Once your colours reflect the coloured bars go to the Chart Menu, Chart Options, in the bottom right click on "Set as default chart". Everytime you then do a new chart it will keep your colours. If it is for everybody then you would need to speak with the IT department as the global template would need to be changed.

If you want logos in bars, Pieces of a pie chart, or backgrounds etc then select what needs changing an got to
format / selected ? (depends what you selected) / Fill effects button / Picture tab / select picture button / find picture and click ok. If you have a bar or column chart then in the bottom left you get a stretch or stack option, choose stack. Then when you click OK the logo will go in.

Hope that helps
Regards
Martin

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



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