A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Graphs in Microsoft Word



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2008, 02:43 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Graphs in Microsoft Word

You say, "In Word 2007, the chart engine uses Excel to hold the data." How
does this work if you have a freestanding version of Word (that is, you
don't have Excel 2007 installed)? Do you not get the charting ability?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote
in message ...
Hi Alexsander,

In Word prior to 2007, select the table and use Insert=Picture=Chart will
create a chart/graph of the table data you can then modify.

In Word 2007, the chart engine uses Excel to hold the data. One approach is
to select the table, right click and copy the table data to the clipboard.
Then place the cursor in your Word document where you want the chart,
Insert=Chart and in the spread sheet that comes up select and paste over
the sample data.

============
"Aleksander" wrote in message
...
Hello,

The data is put in Microsoft Word table. The problem is to put the data as a
graph or insert it into the cells of Microsoft Excel table.

Best regards,
Aleksander
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*


  #2  
Old July 12th, 2008, 03:36 PM posted to microsoft.public.word.tables
Bob Buckland ?:-\)
external usenet poster
 
Posts: 5,766
Default Graphs in Microsoft Word

Hi Alexsander,

In Word prior to 2007, select the table and use Insert=Picture=Chart will create a chart/graph of the table data you can then modify.

In Word 2007, the chart engine uses Excel to hold the data. One approach is to select the table, right click and copy the table data to the clipboard. Then place the cursor in your Word document where you want the chart, Insert=Chart and in the spread sheet that comes up select and paste over the sample data.

============
"Aleksander" wrote in message ...
Hello,

The data is put in Microsoft Word table. The problem is to put the data as a graph or insert it into the cells of Microsoft Excel table.

Best regards,
Aleksander
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
  #3  
Old July 13th, 2008, 12:39 AM posted to microsoft.public.word.tables
Aleksander
external usenet poster
 
Posts: 16
Default Graphs in Microsoft Word

Hello,

The data is put in Microsoft Word table. The problem is to put the data as a graph or insert it into the cells of Microsoft Excel table.

Best regards,
Aleksander
  #4  
Old July 13th, 2008, 02:45 AM posted to microsoft.public.word.tables
Aleksander
external usenet poster
 
Posts: 16
Default Graphs in Microsoft Word

Dear Bob Buckland and Suzanne,

Table consists of two columns. I need to put the graph with the values of the first column as X-coordinate and the values of the second column as Y-coordinate.
As I understand, this corresponds to giving Data range in Chart Wizard (Step 2 of 4), when using Microsoft Excel tables. How can I make this?

Best regards,
Aleksander

"Suzanne S. Barnhill" wrote in message ...
You say, "In Word 2007, the chart engine uses Excel to hold the data." How
does this work if you have a freestanding version of Word (that is, you
don't have Excel 2007 installed)? Do you not get the charting ability?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote
in message ...
Hi Alexsander,

In Word prior to 2007, select the table and use Insert=Picture=Chart will
create a chart/graph of the table data you can then modify.

In Word 2007, the chart engine uses Excel to hold the data. One approach is
to select the table, right click and copy the table data to the clipboard.
Then place the cursor in your Word document where you want the chart,
Insert=Chart and in the spread sheet that comes up select and paste over
the sample data.

============
"Aleksander" wrote in message
...
Hello,

The data is put in Microsoft Word table. The problem is to put the data as a
graph or insert it into the cells of Microsoft Excel table.

Best regards,
Aleksander
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*


  #5  
Old July 13th, 2008, 04:15 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Graphs in Microsoft Word

So this would use the old Microsoft Graph applet? That would actually suit
me just as well since I'm comfortable with it (not that I've ever *liked*
it, but over many years I've figured out how to use it).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote
in message ...
Hi Suzanne,

As I understand, in a standalone Word 2007 install, using Insert=Chart on
the Word 2007 Ribbon would be similar to what you'll see
if you use an Office 2007 package and use Office Button=Save As=Word
97-2003 document and then using Insert=Chart.

=============
"Suzanne S. Barnhill" wrote in message
...
You say, "In Word 2007, the chart engine uses Excel to hold the data." How
does this work if you have a freestanding version of Word (that is, you
don't have Excel 2007 installed)? Do you not get the charting ability?

Suzanne S. Barnhill
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*






  #6  
Old July 13th, 2008, 04:53 AM posted to microsoft.public.word.tables
Bob Buckland ?:-\)
external usenet poster
 
Posts: 5,766
Default Graphs in Microsoft Word

Hi Suzanne,

As I understand, in a standalone Word 2007 install, using Insert=Chart on the Word 2007 Ribbon would be similar to what you'll see
if you use an Office 2007 package and use Office Button=Save As=Word 97-2003 document and then using Insert=Chart.

=============
"Suzanne S. Barnhill" wrote in message ...
You say, "In Word 2007, the chart engine uses Excel to hold the data." How
does this work if you have a freestanding version of Word (that is, you
don't have Excel 2007 installed)? Do you not get the charting ability?

Suzanne S. Barnhill
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*


  #7  
Old July 13th, 2008, 04:54 AM posted to microsoft.public.word.tables
Bob Buckland ?:-\)
external usenet poster
 
Posts: 5,766
Default Graphs in Microsoft Word

Hi Suzanne,

Yes, that's the one Word calls MSGraph.exe to create the graphs and embeds an Ole object. With the new Chart engine it embeds a
picture/shape for the graph and an Excel .xlsx file.

===========
"Suzanne S. Barnhill" wrote in message ...
So this would use the old Microsoft Graph applet? That would actually suit
me just as well since I'm comfortable with it (not that I've ever *liked*
it, but over many years I've figured out how to use it).

--
Suzanne S. Barnhill
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*


  #8  
Old July 13th, 2008, 01:50 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Graphs in Microsoft Word

Okay, thanks.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote
in message ...
Hi Suzanne,

Yes, that's the one Word calls MSGraph.exe to create the graphs and
embeds an Ole object. With the new Chart engine it embeds a
picture/shape for the graph and an Excel .xlsx file.

===========
"Suzanne S. Barnhill" wrote in message
...
So this would use the old Microsoft Graph applet? That would actually suit
me just as well since I'm comfortable with it (not that I've ever *liked*
it, but over many years I've figured out how to use it).

--
Suzanne S. Barnhill
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*





  #9  
Old July 13th, 2008, 03:23 PM posted to microsoft.public.word.tables
Bob Buckland ?:-\)
external usenet poster
 
Posts: 5,766
Default Graphs in Microsoft Word

Hi Alexsander,

Generally, the default is for each column in the table would be a 'series' on the X-Axis, while the values in the rows would determine the upper/lower boundary range that is shown on the Y-[vertical] axis of the chart.

In some chart types you can select to put a series on a second data axis. Are you using 3D charts or 2D? Do you have a small sample of the data table you're using and what graph type you're selecting in Word?

You can use the Chart Wizard in Excel if you prefer and paste/link that chart into Word.


===============
"Aleksander" wrote in message ...
Dear Bob Buckland and Suzanne,

Table consists of two columns. I need to put the graph with the values of the first column as X-coordinate and the values of the second column as Y-coordinate.
As I understand, this corresponds to giving Data range in Chart Wizard (Step 2 of 4), when using Microsoft Excel tables. How can I make this?

Best regards,
Aleksander
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
  #10  
Old July 14th, 2008, 05:18 AM posted to microsoft.public.word.tables
Aleksander
external usenet poster
 
Posts: 16
Default Graphs in Microsoft Word

Dear Bob Buckland ?:-),

I am using Chart with Chart Type-Standart Types-XY (Scatter)-Scatter with data points connected by lines. The sample of the data is small.
Is it possible to insert data from Microsoft Excel table in to the Microsoft Word document (for example, as Insert-Reference-Cross-reference).

Best regards,
Aleksander
"Bob Buckland ?:-)" 75214.226(At Beautiful Downtown)compuserve.com wrote in message ...
Hi Alexsander,

Generally, the default is for each column in the table would be a 'series' on the X-Axis, while the values in the rows would determine the upper/lower boundary range that is shown on the Y-[vertical] axis of the chart.

In some chart types you can select to put a series on a second data axis. Are you using 3D charts or 2D? Do you have a small sample of the data table you're using and what graph type you're selecting in Word?

You can use the Chart Wizard in Excel if you prefer and paste/link that chart into Word.


===============
"Aleksander" wrote in message ...
Dear Bob Buckland and Suzanne,

Table consists of two columns. I need to put the graph with the values of the first column as X-coordinate and the values of the second column as Y-coordinate.
As I understand, this corresponds to giving Data range in Chart Wizard (Step 2 of 4), when using Microsoft Excel tables. How can I make this?

Best regards,
Aleksander
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.