Adding a second series to an existing chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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).
 
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
 
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
 
Back
Top