Tag Archives: tables

Use MS Graph to Convert Word Tables to Charts

Excel, Word, , , , , , , , ,

Convert Word Tables to Charts

Switching back and forth from Word to an Excel spreadsheet to depict numerical data from a table in your document can be awkward as the Chart feature does not play well with a table. Instead, use MS Graph to convert Word tables to charts inside Word so that you have both your original table and a graph based on that data.

 

Convert Chart in Word with MS Graph

Steps to create a Microsoft Graph Chart

Inside of Word:

  1. Select your table.
  2. Click Insert tab on the ribbon.
  3. In the Text group, click the Object icon to display the dialog box.
  4. Scroll down the list of objects and choose Microsoft Graph Chart.
  5. Click on OK to display a columnar graph of your table (default style).
  West Central East
Qtr 1 9110 9005 11600
Qtr 2 9845 10700 8940
Qtr 3 11660 9995 8850
Qtr 4 14990 13445 12360

What if I don’t like the formatting or the figures change in the future? Can I edit or do I have to redo the whole table and/or chart? Funny you should ask. Thankfully, no, and here’s the fix…

Format the Graph

MS Graph behaves differently than most special features in Office in that clicking it does not automatically display a contextual ribbon for formatting. However, double clicking on the graph border (or in white space inside the border) will activate a toolbar so that you can change the chart type and other formatting. A Datasheet will also display.*

Edit the Data

Changing the figures in the table will not update the graph. Edit the figures by double clicking the graph to display a data table and a toolbar at top of window. This Datasheet can be moved above or below your graph by dragging its title bar. Make changes in the Datasheet and watch the graph auto update. When done click outside of the data table and graph (or press ESC) to return to your regular ribbon. (Your original table will not change).*

*Editing and formatting the graph can also be done by right clicking in the graph and choosing Edit or Open.

As much as I love all the continuous new features in MS Office, sometimes the old stuff does the trick!

Let me know if this was new to you and/or how you used it to amplify your Word document or report.

Want more options for using tables, graphs and charts? Check out some of the Excel posts here:

Use Excel Sparklines Instead of Charts to Display Data Trends

The Magic of Excel Tables

 

 

 

Convert Text to and from Tables in Microsoft Word

Office, Word, , , , , , ,

Convert Text to Table

If you have to create lists in Word and line up the text in separate columns, you have probably had a few frustrating moments! This is actually an easy fix if you have used the TAB key and only pressed it once between each piece of information. Where we usually run into trouble is when the space bar is used to create the needed space and/or the TAB key pressed more than once.

Let’s say I’m doing a simple list with names and department. I am hitting the TAB key once between each column which will look odd and not seem like the way to go but it is what works. ENTER is pressed at the end of each line. (Show/Hide is turned on to show the formatting marks for TAB and ENTER):

This looks like a dog’s breakfast but not for long. Make sure the text that is to be converted into the table contains only a single tab character between each column. (It could also be a comma for the separator).

Here’s how to have a neat, organized list in no time.

  1. Select the text you want converted into a table. (Avoid paragraph markers above and
    below the text).
  2. Display the Insert tab of the ribbon.
  3. Click the Table tool and then click Convert Text to Table. Word displays the Convert
    Text to Table dialog box.
  4. Make sure all the table settings in the dialog box are correct. (In this case, the Number of columns should be 3 and the Separate text at should be Tabs. (Word will automatically do this but always wise to check).
  5. Click OK to display a table.

Not only is this neat, you now have all the advantages of table formatting. When you click in the table, two new tabs will display at the end of the Ribbon under Table
Tools. The Design and Layout tabs give quick, professional looking formatting options. Most of them display a live preview when you mouse-over each selection. Can’t get much faster than that!

Remove Borders

Prefer to just have the text displayed as columns?  Remove the cell borders:

  1. Click in the table. Design and Layout tabs will display at the end of the Ribbon.
  2. From the Layout tab | Table group; click drop down arrow on Select and choose Select All (can also click the + symbol at upper left of table if it displays when you click in the table).
  3. Click the Design tab | Borders group and the drop down on the Borders icon. Choose No Border.

There you go, nice neat columns! (This is still a table, just without borders displayed).

Convert a Table to Text

No sooner do you get this accomplished when you find you have tables that need to be converted to text. You can convert the entire table or just specific rows:

  • Select the rows or table you want to convert to text.
  • On the Layout tab | Data group (at end of Ribbon), click Convert to Text.

  • The Convert to Text box displays. Under Separate text with, click the separator character you want to replace table cells (in this case, TAB) .

  • Click OK.

Here’s the results:

Note that the column spacing is based on your original table but can be adjusted by changing the tab stops. (These display on the ruler when the text is selected and can be just dragged to desired width).

This feature is a great trick also for a paste from Excel (and other programs), as the paste can sometimes produce strange results!

How would you use these features in your Word formatting?