Re: Copy a Data Series Between Charts???
From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 09/09/04
- Next message: WFT Engr: "How do I display the last full cell in a column on another sheet?"
- Previous message: Lars: "How do I import a list of filenames from Explorer to Excel?"
- In reply to: phil6666: "Copy a Data Series Between Charts???"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 09 Sep 2004 17:14:10 -0400
Select a series in one chart, and you'll see its formula in the formula bar
Highlight the formula and copy it.
Press the Enter key, or Esc key, to exit the formula
Select the other chart
Click in the Formula bar, and Paste.
phil6666 wrote:
> Hi-
>
> I'm using Excel 2002 and I've got a lot of graphs, all of which are
> based on a common spreadsheet, which require the regular movement of
> data series between the graphs.
>
> It would be wonderful if there was a simple way to cut & paste or copy
> these data series between the graphs.
>
> Can it be done?
>
>
> Someone asked for more specific info...here it is:
>
>
>>I have a spreadsheet that shows data for all 50 states.
>>
>>I have about 10 graphs which show this data, but only for certain
>>states. (All graphs are very similar, except for which states are on
>>which graph.)
>>
>>Graph #1 might have NY and 9 other states.
>>
>>Graph #2 might have NC and 9 other states.
>>
>>After a month, I might have to move NY to graph #2 and NC to graph #1.
>>
>>Is there a way to copy/paste the "data series" for NY to move it to
>>graph #2?
>
>
> thnx
-- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
- Next message: WFT Engr: "How do I display the last full cell in a column on another sheet?"
- Previous message: Lars: "How do I import a list of filenames from Explorer to Excel?"
- In reply to: phil6666: "Copy a Data Series Between Charts???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
