Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 10, 03:59 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 1
Default Adding a new line to an existing graph, using excel 2007

Hi:

I would like instructions on how to add a new line to an existing graph
(that already has 5 lines), using Excel 2007. The data is already in my
spreadsheet.
--
jim white

  #2   Report Post  
Old February 23rd 10, 05:14 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default Adding a new line to an existing graph, using excel 2007

EXCEL 2007

1. Right click in the graph.

2. Of the options that become displayed select:-

Select Data . . .

3. Select Data Source window should launch.

4. Highlight the extended range of data you want to include in your graph
(including the new data).

5. Hit OK.

6. The 6th line should get added to your graph.

If my comments have helped please hit Yes.

Thanks.



"jim white" wrote:

Hi:

I would like instructions on how to add a new line to an existing graph
(that already has 5 lines), using Excel 2007. The data is already in my
spreadsheet.
--
jim white

  #3   Report Post  
Old February 24th 10, 12:48 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Adding a new line to an existing graph, using excel 2007

Copy the data, select the chart, paste special, add as new series (selecting
appropriate options).
--
David Biddulph


"jim white" wrote in message
...
Hi:

I would like instructions on how to add a new line to an existing graph
(that already has 5 lines), using Excel 2007. The data is already in my
spreadsheet.
--
jim white





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
Excel 2007; graph the best fit line from a regression analysis? mattz Charts and Charting in Excel 1 October 7th 08 11:28 PM
Adding a Second and Third Line to an Existing Stacked Bar/Line Cha billbrandi Charts and Charting in Excel 3 September 12th 08 03:27 PM
average Line created in an existing line graph- based on one cell Melanie Charts and Charting in Excel 2 December 27th 07 09:14 PM
adding a line to an existing chart JudyT Charts and Charting in Excel 2 August 6th 07 04:26 PM
Adding a Baseline Value into my existing column graph. snickers713 Excel Worksheet Functions 0 December 20th 05 06:09 PM


All times are GMT +1. The time now is 09:26 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017