Using Microsoft Graph

by Allen Wyatt
(last updated October 29, 2015)

3

Microsoft Graph is a simple graphing program provided with Word. It includes the ability to view your graph data in both spreadsheet and graph formats. The graphs you create can be inserted directly into your documents. Microsoft Graph is not as full-featured as Excel, but it does allow you to quickly add graphical information without the need of using Excel.

If your document already has a Microsoft Graph chart in it, you can access the program by double-clicking the chart. If you want to insert a new chart, display the Insert tab of the ribbon. Click the Object tool in the Text group. Word displays the Object dialog box. Choose the Microsoft Graph Chart object type and click on OK.

If you have a need to work with Microsoft Graph quite a bit, you may want to add the Insert Chart tool to the Quick Access toolbar. Follow these steps:

  1. Click the Office button and then click Word Options. Word displays the Word Options dialog box.
  2. At the left side of the dialog box click Customize. (See Figure 1.)
  3. Figure 1. The Customize area of the Word Options dialog box.

  4. Using the Choose Commands From drop-down list, choose Insert Tab.
  5. From the list of available commands, choose Insert Chart.
  6. Click the Add button. The Insert Chart command moves to the right side of the dialog box.
  7. Click OK. The command is now available on the Quick Access toolbar.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6269) applies to Microsoft Word 2007.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Picking a Contiguous Range of Table Cells

Creating a table in Word is a relatively simple task. When you want to format or edit information in the table, often the ...

Discover More

Automatically Opening a Document at a Specific Zoom Setting

Do you prefer to have your documents open at a specific zoom magnification? You can get whatever magnification you desire ...

Discover More

Setting a VBA Variable From a Bookmark

Bookmarks are quite helpful in a document. You may want to transfer the contents of a bookmark into a macro variable in ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (ribbon)

Inserting an Image On a Specific Page

Macros are great for processing a document just the way you want. You can even use them to insert graphics, as described ...

Discover More

Determining Picture Size in a Macro

When processing a document using a macro, you may need for your macro to figure out the sizes of the images in your ...

Discover More

Capturing a Screen

Windows provides a way of "capturing" the image on the screen into the clipboard. You can then paste the image from the ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 0 + 2?

2019-04-08 19:01:58

Roy

Guys... please... Top Suggestion is to have Python available instead of just VBA:



Python as an Excel scripting language
Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))
5,989
votes
Vote

Daniel shared this idea · Nov 4, 2015 · Flag idea as inappropriate…
Accepting Votes ·

Admin
Excel Team [MSFT] (Product Owner, Office.com) responded · Feb 28, 2018
Wow.
Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.
Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.
We’ll provide updates as we progress on this feature request.
Thanks!
Ashvini Sharma
Lead Program Manager
Excel


5,989 votes for that. Notice 5 lines above the name ("Ashvini Sharma") he says they put out a survey and had over 10,000 responses.

"Wow" to quote him.

Also to quote him:

"Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline."

This was a year and a month ago.

Boy-oh-boy, let's just use the heck out of that site! I've gotta say, I like Allen's style, actually providing things and responding to questions a WHOLE LOT BETTER.

Over 10,000 reponses on a site whose Sugegstions usually hit a dozen or two votes at best and 13 months ago they finished off their response to that with "... without any specific timeline."

They want to push us all to use PowerApps and easily triple their used-to-be-done-with-Excel revenue stream via PowerApps and its discrete subscription model. (I give examples on a couple of the nearer-to-the-top Suggestions on that site, won't bore you here (well, with THAT anyway, you be the judge on the rest of this post).)

Allen, my friend, you need to start a new product advice site here, for PowerApps, as we will all need smart peoples' insight as we are bum-rushed over to it.

There's pretty high one for having one Undo stack per spreadsheet, and lots of related things like the very particular one Allen found. 10-20 pretty decent other Suggestions there to, if you don't mind tilting at windmills. (I voted, so I guess I don't mind.)


2019-04-08 09:54:07

R

@Graham, I agree that the response from Microsoft on these suggestions is very poor, but it's not quite zero. For example if you click on the Editing category (542 threads) then click on 'Top ideas' you can see some sort of response from them on just the top 5, only 3 of which are (approximately) within the last year. The 5th one has 235 votes, which sets rather a high bar - the thread on the Undo stack and auditing tools has only struggled up to 22 votes since Allen posted his article.

The possibly good news is that one of those top 5 also concerns the Undo stack ("Make Undo stacks track per workbook instead of globally", an even more important issue IMO):
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10555248-make-undo-stacks-track-per-workbook-instead-of-glo

The response from John (Excel Team [MSFT] (Product Owner, Office.com)) in that thread includes "we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications", which gives me some hope that the issue with auditing tools might get swept up if Microsoft ever address the other issues with the Undo stack.


2019-04-07 13:41:14

Graham

Allen, sorry but the UserVoice site is a total waste of time!

Microsoft don't care ONE JOT, and aren't taking any notice of it.

Even ideas with thousands of votes show both no progress, and no response from Microsoft.

It appears they set it up hoping for fancy new stuff to code, but instead got a response of "Fix all these existing problems and daft settings" ... and soon lost interest!

They won't listen and don't care!

+++++

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36927430-here-s-an-idea-respond-to-our-comments-provide
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11706627-restore-mdi-file-handling-open-all-files-in-one-w
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10374741-stop-excel-from-changing-large-numbers-actually
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9769824-have-excel-scroll-better-when-there-are-large-cell
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31663255-add-center-across-selection-to-the-merge-center


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.