Solved

Copying tabular data from excel to PowerPoint

Posted on 2014-10-26
4
368 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
  • 2
4 Comments
 
LVL 21

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 31

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 31

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 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