Question about Microsoft Office Standard 2007: Windows

2 Answers

Hi! I am now inserting Excel graphs into WORD 2007. For efficiency, should I just copy paste or should I use graph insert button and then choose excel sheet?

Posted by on

  • 1 more comment 
  • naonaojoyful Aug 23, 2010

    Thank you for your solution, for now it is fine to insert the excel file in 2007. What about PPT file?

    Should I just copy and paste using sizing tool I have or should I insert from the insert tab...choose the graph in my drive,, what is the difference? Also How to delete the graph's background lines I just can not erase the background data line by right click, choose the settings.

  • naonaojoyful Aug 23, 2010

    Somehow my second question has been deleted and not transffered to you. It seemed like I asked the same question twice by paying twice. Could you help me out with this second question that I submited which somehow could not transffered to FixYa?

    I am writing a report with graphs and tables with words using WORD as a master and PPT and EXCEL for graphs. I am using master document using outlines.

    The purposed outline goes like this.... seperate the top and the bottom, and on the top part, write the paragraphs and on the bottom part, add two graphs and tables in parallel.

    The thing is, If I create outlines by seperating section for each part. I can not put the third graphs up on the bottom right of the first page.What I did was copy and paste the third section graphs and words on to the left bottom empty space but on the outline this part can not be appeared.

    How can I put the third section parts on the left bottom first page to make the sheet look better?



    Thank you for your cooperation in advance.

  • naonaojoyful Aug 23, 2010

    Hi.Somehow my second question with payment could not be transffered to your side and I have got an email saying that in replacement I could get another assistance for free or get my money back. Could you help me out with this question belows?

    In regard to using color pallette, I have an example of turquoise 50% but I need to make 5% turquoise. I know that I have to add three numbers for the color but How to refer the known turqupose 50% color code to get 5% turquoise color?

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Contributor
  • 857 Answers

  1. Paste the chart or worksheet range as a picture.
  2. 1.In Excel, and do ctrl-c. Or, select the cells you want to appear in your Word document and do ctrl-c. Instead of ctrl-c, in Word 2003 and earlier versions, you can do Edit > Copy. In Word 2007 and Word 2010, you can do Home > Copy.
    2.Switch to Word.
    3.In Word, triple-click the paragraph that says "Put my Excel chart here". (That selects the whole paragraph and its paragraph marker.)
    4.Now, paste the picture.
    •In Word 2003 and earlier versions, do Edit > Paste Special and choose Picture (Enhanced Metafile).
    •In Word 2007 and Word 2010, on the Home tab, click the bottom of the Paste split button and choose Paste Special. Then choose Picture (Enhanced Metafile).
    •In any version, if you want to link the Excel workbook and the Word document (so the Word document will update whenever the Excel workbook changes, then click the Paste Link option). And click OK.
  3. 5.The next step is to set the text wrapping so the picture is in line with text.
    •In Word 2003 and earlier versions, double-click the chart or range you have just pasted, so you see the Format Picture dialog box. At the top of that dialog box, click the Layout tab. On the Layout tab, click In line with text and click OK.
  4. •In Word 2007 and Word 2010, double-click the chart or range you have just pasted. This will open the Picture Tools Format contextual tab. In the Arrange group, choose Wrap Text > In line with text.
    6.Done! You now have a landscape chart or region of a worksheet in your Word document. Use File > Print Preview to check. To fine tune the formatting, or sort out headers and footers, read on.Hi! I am now inserting Excel graphs into WORD - e9693b0.gif

Posted on Aug 23, 2010

  • Jayant Jha Aug 23, 2010

    FOLLOW THESE steps Embed Excel Files into Word.


    •1 Open Microsoft Word. You can either open a blank document or an existing document.

    •2 Click on the location in your document where you wish to embed your spreadsheet.

    •3 Go to the "Insert" menu and select "Object" to open the wizard.

    •4 Click the correct tab. "Create New "allows you to create a new file and then embed it into your Word document, while "Create from File" allows you to browse for an existing file. If you want to create a new file, choose "Microsoft Excel Worksheet" from the drop-down list, and check "Display as Icon" to only display the spreadsheet as a clickable icon. If you are going to create a spreadsheet from file, browse your files and select the spreadsheet you want to embed. Choose to display the spreadsheet as an icon or link as well as the full object.

    •5 Click "OK" when finished with Step 4 to embed your object. If you didn’t choose to display the spreadsheet as an icon or link, you will see the first sheet of the workbook in your Word document. Click the spreadsheet object to view any other sheets and also to change data.

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 4,924 Answers

If you already have them in another file ...you can try to just copy /paste them ..but in this case you might end up just with the data and no tab ...cause sometimes it do not copy the whole tab ....and my advice in this case is try with insert button ..and than try to browse fro the file you need to insert and see if it works ..if it is not working you will have to choose insert ..excel sheet ..and after that either manually write the data ..or try to copy /paste the data from the other tab ..It might just work and fit in the new one ..if you choose to make it the same ..
But I think it will work with insert ..and browse for the file and insert it all at once..

Posted on Aug 23, 2010

  • 1 more comment 
  • Catalin Turcu
    Catalin Turcu Aug 23, 2010

    Unfortunately ..I just checked and will not work ...you will have to build it manually into the word...cause if you try to copy /paste will copy just the written data without the tab itself ...and if you try to copy the data over the tab in word..it will overwrite the tab and end up with the data only ...so ..you have to click insert tab ..from the list choose excel spreadsheet ..and the data you have to complete manually ..

  • Catalin Turcu
    Catalin Turcu Aug 23, 2010

    I found another way to insert the tab from the excel file directly ..without being needed to write it again ..but you will not be able to make modifications on it ..
    you need a photo program like the one I will link below ..and in that program it has a capture feature..and if you open the excel tab ..and make a region capture with the tab itself..it will be save like a JPG ..and you will be able to insert like a photo after that ...In case that you make a paper and you need the tab inside just like a reference ..and not to be modified after ..this is the faster solution ..It will take about 2 minutes to install the program ..and when you open it ..on the primary menu you have the feature called screen capture..
    choose it ..and open the excel file ...than choose capture region ..crop the region with care ..by click in the left corner and guide to the corner in the lower right ..save the capture on desktop from the photoscape program ..and after that just insert the jpg picture with the tab in the word..
    This will be helpful if you have to make multiple insertions ..and you do not need to modify the content after ..
    Here is the program I mentioned..
    http://www.mediafire.com/file/mzzjojmljj...

  • Catalin Turcu
    Catalin Turcu Aug 23, 2010

    for the graphs and tabs ..just make them smaller to fit all ...on the page ,,,and for the color ..just get to more..and then adjust the color by eye ....Another thing ..if you click in front of a graphic or a tab ...and than press space it will move just like you move a row..or a word..so ..If I ware in your place and insert 3 tabs or graphs ..I would put the 3rd in the middle....and for graphics..is better to insert than copy paste ..this way you have the original quality ..and you can easy change the size from the corner..after that you can move it by clicking in front of it ..left low..and press space to move ..

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi, can someone help me how to properly embed graphics on MS 2007? i need to attached an image on the file itself that i could open in another computer.


Hi!
Here are the steps to take:
  1. In Microsoft Word, Excel or Powerpoint you have to click on the insert tab on the top.
  2. Click on Picture.
  3. It would then show the "Insert Picture" window.
  4. Go to the directory or folder where you have the image saved.
  5. Choose the file or highlight the file.
  6. On the right side of the insert button is an arrow. Click the arrow and you will have a dropdown.
  7. Choose "Insert and Link"
And that is it. You have inserted and linked the file in a word, excel or powerpoint file.
If you have any more questions feel free to come by again here at Fixya.com where there are solutions for every thing.
You have a great day!

Feb 15, 2011 | Computers & Internet

1 Answer

How do I create a graph?


go to insert, object and when the drop down table appears choose microsoft graph

Nov 22, 2009 | Microsoft Windows XP Home Edition

1 Answer

Does the Graph/Chart option exist for Mac Excel?


Yes, it does.

Choose the data in which you want to graph by highlighting said data, including and row/column headings. Then click the icon, which looks like a graph, in the top toolbar which will open up the Chart and Graph Wizard. Then follow the steps and guidelines to create your chart or graph.

Hope this helps. Have a great evening!

Feb 17, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Excel stops responding when i click on a graph data point to see its value


Step 1: Go to Msoft update and make sure you have all the latest Office service packs/issue fixes for Office 2007.

If that doesn't work, go on to:

Step 2: Are you using wizards to create the code to do this functionality and if so, what ones? Post here.

Mar 07, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Graph plotting


Dear rachana, In MS word 2007 you can go to Insert then there are multiple graph patterns given in it, like column, pie and scatter chart. Just put your values in it and it click ok, you will get the chart on worksheet. Its that simple.

Please press fixya if that was helpful.

Nov 29, 2007 | Computers & Internet

1 Answer

Excel 2007


Darcy,select the data and then open the graph option then put the values

Sep 20, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard 2007: Windows Logo

132 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...