Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training - Excel Charts

Resolved · Low Priority · Version Standard

Reply Fri 25 Jan 2008, 17:11Delegate marius said...

marius has attended:
Excel Intermediate course
Powerpoint Intermediate Advanced course

Excel Charts

How do i make the graphs more professional?

For upcoming training course dates see: Pricing & availability

Reply Fri 1 Feb 2008, 16:05Trainer Mark said...

RE: Excel Charts

Hi Marius

There are various way of making your graphs more professional, one of the main things to remember is to use the best and most clearest chart for not just you but for the people who will be viewing the graph

when you are going through the chart wizard add things like X and Y titles chart titles, and remember the last step of the wiz is how to view the best way is as a new sheet

one other thing you could use is showing the data sheet you can find this from the chart menu, or from the chart toolbar

hope this helps

Mark East

Excel articles

· Discover The Top Ten Changes In Excel 2010
· Why do we even need XML anyway?
· Tips for Transitioning to Excel 2007
· How To Create An Excel Formula Using Data From Several Worksheets
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips