Jump to content

Recommended Posts

So I have a large powerpoint presentation where I have a total of 24 slides. 
12 of them is going to be showing a chart for illustration with numbers thats going to grow over time. 
So my plan was to have one excel file to insert the current numbers and have that linked to my powerpoint. BUT. 
I don't want all the rows from the excel to be shown in every chart. 
Example, slide 1 will have a chart that has information from Row 1 in excel. 
Slide 2 will have a chart that has information from row 1 & 2, and so on. 


How do I do that? 
My wish is to not need Excel at all, I just want to be able to write my numbers in Slide 1/chart1, and have them somehow linked so they show up in my slide 2/Chart 2. But that seems impossible. 

Please help! 

Link to comment
Share on other sites

Om du har rådata i excel så kan du köra ett länkat diagram (som du har tänkt). Du kan även lägga in en länkad datatabell genom att, i excel:

markera de rader du vill visa

I Powerpoint kör du 
Klistra in special->länkad

Nu skall både tabell och figur ändras som du ändrar data i excel


Att ändra diagramdata i en powerpointtabell tror jag däremot blir svårt. 

Du kan naturligtvis välja att infoga diagrammet direkt i Powerpoint:
Då får du ett dedicerat datablad som ligger inbäddat med diagrammet. Om du högerklickar och väljer "redigera data" så får du fram rådatatabellen. MEN så vitt jag vet kan du inte lägga den som en redigerbar tabell på något annat blad.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...