Adding a second series to an existing chart

[Guest]

I have a very simple question, I would like to add a second series to an
existing chart, how is it done? (I am comparing accidents in 2006 and need a
series line for accidents in 2007)

Thank you,

 

[David Biddulph]

Many ways to try, including:
Chart menu/ Add data
Chart menu/ Source Data/ Series/ Add
Copy your new series, & paste into the chart (and paste special gives you
the choice of new points or new series, together with various other
options).

 

[Guest]

In XL2003 or earlier:
Select the data. Copy. Select the chart then Edit | Paste Special... In
the dialog box that pops up, provide XL the information it requires.
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach

 

[Guest]

Thank you David...the suggestions you gave worked great.

 

[JoAnn Paules]

I'm a dunce! I didn't know that I could do that. You would not believe what
I went thru this morning to fix a typo that I made when setting up the
series. Amazing what you can learn if you're given more than an hour to
learn how to create charts.


--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375