2002 excel microsoft training - excel spreadsheet

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

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

2002 excel microsoft training - Excel spreadsheet

resolvedResolved · Low Priority · Version Standard

Emma has attended:
Excel Introduction course

Excel spreadsheet

how to format a colume of a chart with a picture??

Edited on Wed 9 May 2007, 12:09

RE: excel spreadsheet

Hi Emma,

Thanks for the question.

When you are in the chart click on the column twice, slowly so the small black handles are grabbing the column that you want to change. When that is selected you can use the Format menu and click Format>Selected Data Point.

You should get a dialog box showing with the same colour as the graph. The name of the dialog box is "Format Data Point". Within in that box select the tab "Patterns" and click on the option that says "Fill Effects".

From there click on the tab that says Picture, from there you can select a picture which you have saved, a logo for example.

Good luck and I hope that helps

Tracy


 

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips


Server loaded in 0.09 secs.