Solved

Copying tabular data from excel to PowerPoint

Posted on 2014-10-26
4
376 Views
Last Modified: 2014-11-08
Hi,

I am not able to work around this. I have an excel file with "pivot table" sheet and its related data in "Data" sheet as in the attachment. The copied pivot table data is seen in powerpoint. As you can see the pivot table data looks stretched and is not clear. How can I have this pivot table data copied in smaller font or as the size of the font above and at the same time I want the pivot table fill the ppt slide from left to right as in the attached ppt slide. I want the pivot table as in the attached example but needs to be visible with smaller fonts and no stretched look.
excel-2ppt-issue-example.pptx
pivot-tble-2-PPT.xls
0
Comment
Question by:techEverest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 22

Assisted Solution

by:Ejgil Hedegaard
Ejgil Hedegaard earned 166 total points
ID: 40405130
Seems you want to insert the pivot table as a picture and keep the font size.
Then adjust the column width in Excel, to fit the ppt slide before you copy the picture.

Or copy/paste directly (Ctrl +C / Ctrl +V), then the pivot table in Power Point is adjustable, keeping the font.
0
 
LVL 33

Assisted Solution

by:Paul Sauvé
Paul Sauvé earned 167 total points
ID: 40405157
You can also use Insert tab -> Table -> Excel Spreadsheet

Now you can adjust the column width, copy the cells of the pivot table and adjust the font size...
excel-2ppt-issue-example-1.pptx
0
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 167 total points
ID: 40406054
Use the Excel Camera tool.   You will need to add it to your Quick Access Tool Bar first.   It is in the section "Commands Not in the Ribbon".   Once you have it available...   Highlight the pivot table (or section) and press the camera icon.   Your cursor will turn to a cross, click on another part of your Excel sheet and begin to draw a box.   A picture of the highlighted range will be drawn.  Copy the picture and paste it into the PowerPoint slide.  You can change the dimensions and the table will look the same as in Excel.

The picture in Excel is linked to the range and will change if the pivot table changes.  However, the linkage does not apply to the picture pasted in PowerPoint.   There is also an EE Article on the Camera here: Excel Tips & Tricks: The Camera Tool Adding Camera Tool to QATQ-28544776---PPT.pptx
0
 
LVL 33

Expert Comment

by:Paul Sauvé
ID: 40430809
@ProdOps - I didn't know that the Excel Camera tool even existed!

I suppose you could use the WIn 7 Snipping Tool as well...
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question