Ask Experts Questions for FREE Help !
Ask
    deeptyranjan's Avatar
    deeptyranjan Posts: 1, Reputation: 1
    New Member
     
    #1

    Mar 13, 2007, 11:25 PM
    Connect two different sheet in Excel 2007
    I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet.

    How I would relate these two sheets so that when I make any changes in the figure in the first sheet then it should automatically reflect on second graph sheet
    hadi88's Avatar
    hadi88 Posts: 59, Reputation: 5
    Junior Member
     
    #2

    Mar 15, 2007, 08:28 AM
    I think, if you creat a chart on (let's say) sheet 2 using the data from sheet 1 and you make changes to sheet one, it automatically reflects on sheet 2 (chart), I don't think you need to do anything special, if I understood your question right.


    hadi88
    rrrrr's Avatar
    rrrrr Posts: 1, Reputation: 1
    New Member
     
    #3

    Oct 12, 2011, 12:35 AM
    you can type from sheet2 (=sheet1!A1) try this in a blank sheet
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Oct 12, 2011, 01:08 AM
    1) Try creating the needed pie chart on the same page so that it looks the way you want, then move the chart to another sheet. Does that work?

    2) create a named range of the data you want to serve as the source of the data for your chart, then use that name in chart creation on the second sheet.
    abc.c_bcmon's Avatar
    abc.c_bcmon Posts: 1, Reputation: 1
    New Member
     
    #5

    Dec 8, 2011, 03:39 AM
    Pleas I creat program in c sharp but I can not insert data in table if I stop program the data I insert I cannot found
    ektag's Avatar
    ektag Posts: 1, Reputation: 1
    New Member
     
    #6

    Jan 9, 2012, 09:34 PM
    I have to link 2 sheets but I want some detail in next month but all detail now so what will I do for that
    Reply me soon
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #7

    Jan 10, 2012, 10:45 AM
    The question is not clear.

Not your question? Ask your question View similar questions

 

Add your answer here.


Check out some similar questions!

2007 Superbowl, Colts vs. Bears [ 8 Answers ]

Are the Colts really that good of a team? I just think that they didn't face any hard offenses. But still they did beat the number 1, 2, and 3 defenses. Just looking for some feedback on this question.

F1 to H1B in 2007 [ 1 Answers ]

Hi, I have recently graduated in Dec 2006.I am filing for my H1 this year 2007.I was told that there is a separate kota for F1 to H1b apart from the general H1B kota.But just a week ago,my employer says that the bill has been passed saying that the special kota for F1 to H1B was cancelled from...

What do I claim on my 2007 W-4? [ 1 Answers ]

Hello, I'm a single home owner in Baltimore, MD. I will make $55k this year with salaries and bonuses. I made $47k last year as stated on my W-2. I received back approximately $2,200 from Federal and $640 from the State. I claimed single and 1 in both categories I want to elect exemptions...

Printing in Outlook 2007 [ 0 Answers ]

Hi everybody, I hope many of you will be using Outlook 2007. What I have noticed that there is no option to print a set number of pages in it. For example I am communicating with someone on a particular subject and there are replies and replies which makes the mail 4-5 pages. There is no option to...

Tick Sheet for Excel [ 0 Answers ]

I am creating a "Table of Measurements" for a moving company in Excel, and they require that in the "# of pieces" cells that a number "1" or a similar character be placed in the cell rather than a "2" for two pieces or a "3" for three pieces, etc. So if there are 4 pieces, the cell would have...


View more questions Search