Hi,
The legend part is the simplest. Let say you x values are in A2:A11 and the
y values are B2:B11
Enter the text for the legend in B1; select A1:B11 when making the chart.
Alternatively with existing chart: Right click on chart, open the Source
Data item on the popup menu, open the Series tab on resulting dialog box,
click in the Name box, type = and then click the cell to be used for
legend - Excel enter something line=Sheet1!A20.
For the title; If the existing chart does not have a tile already - right
click chart, open Chart Options menu item, on the Names tab give the chart a
dummy title (My Chart). Now on the chart, click the title, type = and click
on the cell to be used for the title.
Best wishes
