Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Excel, charts

advanced excel training - Excel, charts

ResolvedVersion Standard

Fri 3 Aug 2007, 12:52 Delegate John said...

John has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Excel, charts

I have a chart based on data from a worksheet, i want to be able to add the same format of data from other worksheets within the same file to the chart in order that the chart continues (ie a continous line chart based on month on month data housed within seperate worksheets

Thanks

John

Tue 7 Aug 2007, 11:07 Trainer Richard said...

RE: Excel, charts

From playing around with excel, you will notice that the chart button greys out if you try to chart data from several sheets.

You might want to try and create a summary sheet that pulls all the infor from the various sheets onto one so that you can chart that.

Regards

Richard

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

advanced excel training - Excel, charts

Excel, charts

RE: Excel, charts

Excel articles

Excel tip:

Quickly insert a function