View Full Version : Connect two different sheet in Excel 2007
deeptyranjan
Mar 13, 2007, 11:25 PM
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
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
Oct 12, 2011, 12:35 AM
you can type from sheet2 (=sheet1!A1) try this in a blank sheet
JBeaucaire
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
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
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
Jan 10, 2012, 10:45 AM
The question is not clear.