microsoft excel course - Charts

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

Resolved · Low Priority · Version Standard

Charts

Will has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Will [1 post] (2007 Jul 3 Tue, 12:51) Reply

Why when you highlight the 'dots' on a scatter graph before plotting a line through the 'dots' does it not highlight all the dots. Also, does this mean that they are not being included in the calculation of where to plot the line.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Charts

by - trainer Anthony gold contributer [113 posts] (2007 Jul 10 Tue, 12:50) Reply

Hi Will. In all liklihood if all the dots aren't being highlighted they are comprised of different data series, in which case they won't be part of an overall calculation such as a trendline. Look at your source data and make sure your data is separated into discrete chunks, and then re-plot.

· Excel in the Home Office
· How to Create Better Excel Spreadsheets: Part Three
· Advanced level training: Microsoft Excel and the Web
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Training - Numerical excellence for all

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips