PowerPoint 2008 Mac Chart Data Table

[Rob]

How can I display the data table so as to edit after I have created a chart
in a PowerPoint slide for Mac

 

[Jim Gordon MVP]

How can I display the data table so as to edit after I have created a chart
in a PowerPoint slide for Mac

Hi Rob,

If you created the chart from the elements gallery then aim your mouse
pointer at a chart element, such as a line, slice of a pie chart, or a
bar of a bar graph. Right click (or control click) on the selected item
and a pop-up menu will appear. Choose Edit Data. This opens Excel.

There's a second way to add graphs to PowerPoint. Instead of using
Excel, you can still use Microsoft Graph. To do this, instead of using
the elements gallery to add a graph, use Insert > Object > Microsoft
Graph Object. Doing it this way offers the older interface from earlier
versions of office. You can double-click such a graph in PowerPoint to
edit the data. PowerPoint will try to persuade you to convert it to
Excel, but you can choose Edit Existing to keep it in Microsoft Graph.

Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[Rob]

Jim,

You are a godsend! It worked just as you said. Thank you!

May I ask you another?

When I used a PC and Office 2003, I liked to insert Excel worksheets, edit
them, and use them as tables in PowerPoint slides. I would have my slide up,
then Insert, Object, Excel Worksheet, and a worksheet would appear, and I
would be in Excel within PowerPoint. I would determine the columns and rows
that I wanted displayed by pulling on the borders on the worksheet in Excel.
I would finish and then click outside of Excel and return to PowerPoint, with
the object still outlined. If I wanted to change the shape of the object,
then I would pull on the anchors in PowerPoint, changing the size of the
object but not changing the columns and rows displayed within the object in
Excel.

I can't seem to do the same with Mac and Office 2008.

When I insert a worksheet into a PowerPoint slide, a worksheet appears in
Excel, but I can't seem to size it such as the columns and rows I want
displayed can change. I click back into PowerPoint and can size the object,
but not change the columns and rows I want.

Can you help me?

Rob

 

[Jim Gordon MVP]

Jim,

You are a godsend! It worked just as you said. Thank you!

May I ask you another?

When I used a PC and Office 2003, I liked to insert Excel worksheets, edit
them, and use them as tables in PowerPoint slides. I would have my slide up,
then Insert, Object, Excel Worksheet, and a worksheet would appear, and I
would be in Excel within PowerPoint. I would determine the columns and rows
that I wanted displayed by pulling on the borders on the worksheet in Excel.
I would finish and then click outside of Excel and return to PowerPoint, with
the object still outlined. If I wanted to change the shape of the object,
then I would pull on the anchors in PowerPoint, changing the size of the
object but not changing the columns and rows displayed within the object in
Excel.

I can't seem to do the same with Mac and Office 2008.

When I insert a worksheet into a PowerPoint slide, a worksheet appears in
Excel, but I can't seem to size it such as the columns and rows I want
displayed can change. I click back into PowerPoint and can size the object,
but not change the columns and rows I want.

Can you help me?

Rob

Hi Rob,

Glad I could help. I forgot to mention that you can also select the
graph object in PowerPoint and from the Edit menu choose Edit Data.

I'll help with your second question this time on the assumption that you
will promise that in the future you'll start each question as a totally
new subject. It really will help people who are searching this forum for
answers.

I have a multi-step kludgey solution. Far from ideal, but it works. Here
goes.

When you use Insert > Object > Excel workbook (don't choose as icon)
keep sheet 1 totally blank, and before you close Excel to return to
PowerPoint make sure it is that sheet 1 (or any blank sheet for that
matter) is what is showing.

Before you close Excel and return to PowerPoint select the range that
you would like to have displayed in the Excel placeholder in the
PowerPoint presentation. Hold the shift key down and in Excel, then on
the Edit menu choose Copy Picture. Choose either as shown on screen or
as printed. Then on a sheet where it doesn't matter use edit Paste. You
will then have what you want to appear as the click thing in PowerPoint.
Right click on what you pasted, and then choose Save As Picture. Now
switch back to the blank sheet 1 and close Excel and return to PowerPoint.

When PowerPoint is ready again, right click on the excel placeholder and
choose to format it. In the Colors and Lines section click the Fill
Color popup control. Choose Fill Effects. Click the Picture tab. Click
the Select Picture button. Navigate to the picture you saved from Excel.
Click the Insert Button. Click the OK button. Resize as desired.

It's a lot of steps, but you get exactly the right snapshot this way.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9