Excel

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

Resolved · Low Priority · Version 2003

Excel

Sue has attended:
Excel Introduction course

by - delegate Sue [1 post] (2008 Apr 23 Wed, 16:49) Reply

How do I edit my data source for a chart?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel

by - trainer Pete platinum contributer [600 posts] (2008 Apr 24 Thu, 09:21) Edited on 2008 Apr 24 Thu, 09:22 Reply

Hi Sue, Thank you for your post, welcome to the forum, in answer to your question, the data source for your chart is either on the same sheet, or if your chart is on a chart sheet will be in another sheet or even workbook. To edit the data on the chart, you must return to the original data, and make your changes there, the chart will immediatly reflect these changes. To quickly get back to the source data, if you are on a separate sheet, click the Chart to select it, then choose the menu command Chart>Source Data, this will open the data sheet and show the Source data dialog box which allows you to make your required changes.
I hope that has helped, best regards Pete

· Tips to Facilitate Printing of Excel worksheets
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Tap the Power of Recorded Macros with MS Excel Courses
· Crazy Things People Have Done With Excel
· Customized Financial Excel Courses in London

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips