excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Ian has attended:
Excel Introduction course

Excel

How do I best create a date specific line chart within excel

RE: Excel

Hi Ian

Thank you for your question and welcome to the forum.

To create a line chart in Excel:

1. Select the data you wish to have represented in the chart - in this case, the dates and corresponding data you wish to plot.

2. Go to the Chart Wizard on the standard toolbar.

3. At step 1, select Line as the type of chart you wish to create.

4. At step 2, check your chart looks ok. If it doesn't you may need to Cancel out of the Chart Wizard and try reselecting your data.

5. At step 3, add your chart and axes titles.

6. At step 4, decide where you want the chart to go - on the same sheet as the data, or on a new sheet by itself.

Kind regards
Amanda


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.09 secs.