series titles

J

Jon Peltier

I find the easiest way to be changing the series formula. Select the series,
and in the formula bar is a formula that looks like this:

=SERIES([name],[x values],[y values],[plot order])

The [name] part can be blank, resulting in Series 1, Series 2 names, or text
enclosed in quotes, or a link to a cell.

=SERIES(,Sheet1!$D$4:$D$10,Sheet1!$E$4:$E$10,1)
=SERIES("The Series",Sheet1!$D$4:$D$10,Sheet1!$E$4:$E$10,1)
=SERIES(Sheet1!$E$3,Sheet1!$D$4:$D$10,Sheet1!$E$4:$E$10,1)

If you want to use a dialog approach in Excel 2007:

Chart Tools > Design tab > Select Data
Select the series in the Select Data Source dialog, click the Edit button,
and in the Series Name box, type what you want (no need for quotes, Excel
fills them in when you click OK), or with the cursor in the Series Name box,
click on the cell with the series name text.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top