Powerpoint and Excel link problem

[f.w.johansson]

I don't work much with Powerpoint so i hope you will understand what i'm
trying to do.. Basically, have an Excel sheet with data and i have a
Powerpoint presentation with almost 200 slides. Each slide has a different
graph (values and data are different). I am trying to link each slide to
specific cells in the Excel sheet and to have them updated automatically,
i.e. when i edit the data in the Excel sheet, the data is automatically
updated in corresponding slides. I have two problems, first, i can easily
link the data but the appearance in the slide is a "table", like in Excel,
what i need is to have it presented (converted to) as a graph automatically.
Secondly, since i add columns every month i would consequently like to "hide"
the earlier columns. The graph should present a fixed number of columns and
rows and when i add a column i would like to hide another. I have tried to
hide the column in the original excel sheet but it stills shows in the slide.
Until now i have to edit (select data) manually each graph in each slide and
when hiding a column while working in Powerpoint all is ok. Is there any way
to edit the data ONLY in the original Excel file and to have it updated and
transformed into a graph in a Powerpoint slide?

Any help would be highly appreciated,
Best regards

 

[f.w.johansson]

Thank you for your answer, appreciate it alot. My english is not the best and
my knowledge of Excel is even worse so i'll need to check it out to see if i
can get things right concerning "chart sheet". I think i tried something
similar; i simply selected cells and made a graph of those, i repeated the
process with other cells and kept the all the graphs in the same worksheet,
then i did what you said, copy graph>PPT paste special/link. Then it got all
messed up and i gave up. I'll check out the "new chart" thing and then i'll
let you know about it. Thank you again, best regards,
Fredrik