Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 85
Default Adding a second series to an existing chart

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,
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 620
Default Adding a second series to an existing chart

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).
--
David Biddulph

"Angela" wrote in message
...
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,



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default Adding a second series to an existing chart

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


"Angela" wrote:

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,

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 85
Default Adding a second series to an existing chart

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

"David Biddulph" wrote:

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).
--
David Biddulph

"Angela" wrote in message
...
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,




  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default Adding a second series to an existing chart

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

"David Biddulph" wrote in message
...
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).
--
David Biddulph

"Angela" wrote in message
...
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,





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
excel chart maximum series should more than 255 series kameking Charts and Charting in Excel 5 August 22nd 10 10:52 AM
Chart series (based on datarange content) alecswan Excel Discussion (Misc queries) 0 July 19th 06 09:50 PM
Chart series Arne Hegefors Charts and Charting in Excel 0 July 18th 06 01:59 PM
Adding data series to chart via macro JessK Charts and Charting in Excel 1 March 1st 06 11:04 PM


All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"