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

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

you can type from sheet2 (=sheet1!A1) try this in a blank sheet

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.

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

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

The question is not clear.