Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Tables

	98.1 % recommend us
	More live stats...

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

Training information:

vba-excel-training - Tables

Resolved · Low Priority · Version Standard

Reply Tue 13 Nov 2007, 17:13Delegate Stewart said...

Stewart has attended:
Excel Intermediate course

Tables

How do you convert a special table to a normal table?

For upcoming training course dates see: Pricing & availability

Reply Thu 15 Nov 2007, 15:09Trainer Pete said...

RE: Tables

Hi Stewart, thanks for the post, I wonder if you could add a little bit more explanation to your question ie what do you mean by a special table? please give an example if you can. Regards Pete

Excel articles

· How To Add A Second Axis To An Excel Line Chart
· Creating Charts with Excel
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· Make A Custom Sort List In Excel

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy