Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

charts

ResolvedVersion 2007

Simon has attended:
Excel Intermediate course

Charts

i have trouble with a chart template. the linetypes dont stay the same when i put new data in to the chart.

RE: charts

Hi Simon

Thank you for your question; and welcome to the forum.

Could you provide a little more detail on the specific problem you are having, e.g.

When you refer to a chart template, do you mean the chart has been created from one of the chart types you have selected from the Insert ribbon?

What type of chart did you select from the options provided?

How are you putting new data into the chart?

Is the data you are putting in additional to the data you have already charted (e.g. you have created a graph for January to May and you are adding in June) or are you graphing different data altogether?

Amanda

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.