Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruce
 
Posts: n/a
Default Can you make a gantt chart in excel and import it to Project

If I set up something in Excel similar to a gnatt chart along with the data,
can I import it safely to Project later? Any help would be useful I have
experience with Excel and not with Project so any help would be welcomed.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Can you make a gantt chart in excel and import it to Project

Bruce

I don't use Project although I do have it installed.

From Project 2003 Help on "import from excel"

Before distributing your project to team members, executives, or other
stakeholders, you may want to add graphics such as your company's logo or a
project-related Microsoft Office Excel 2003 chart. Graphics give reports a
finished look, clarify or enhance information, and draw attention to important
information.

Looks like you can import a Chart from Excel.

Quite a bit in Help about importing from other applications.

Lotsa luck!


Gord Dibben Excel MVP


On Fri, 18 Nov 2005 17:16:04 -0800, "Bruce"
wrote:

If I set up something in Excel similar to a gnatt chart along with the data,
can I import it safely to Project later? Any help would be useful I have
experience with Excel and not with Project so any help would be welcomed.


  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier
 
Posts: n/a
Default Can you make a gantt chart in excel and import it to Project

You can import a chart, but I think the idea is to import whatever
schedule/manpower/whatever info you have in Excel into Project, so you can
draw a more powerful Gantt chart in Project. If you're going to be using
Project, your time is better spent learning how to use it, rather than
trying to use Excel to make Gantt charts to import into Excel. That'd be
like making charts out of drawing objects in PowerPoint to import into
Excel!

You can get pretty fancy with Gantt charts in Excel:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

but it's a matter of using the right wrench to pound in the right screw.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Bruce

I don't use Project although I do have it installed.

From Project 2003 Help on "import from excel"

Before distributing your project to team members, executives, or other
stakeholders, you may want to add graphics such as your company's logo or
a
project-related Microsoft Office Excel 2003 chart. Graphics give reports a
finished look, clarify or enhance information, and draw attention to
important
information.

Looks like you can import a Chart from Excel.

Quite a bit in Help about importing from other applications.

Lotsa luck!


Gord Dibben Excel MVP


On Fri, 18 Nov 2005 17:16:04 -0800, "Bruce"

wrote:

If I set up something in Excel similar to a gnatt chart along with the
data,
can I import it safely to Project later? Any help would be useful I have
experience with Excel and not with Project so any help would be welcomed.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
How do I import MS Project data into Excel? mk Excel Discussion (Misc queries) 1 March 30th 05 07:57 PM
How do I import MS Project data into Excel? mk Excel Discussion (Misc queries) 0 March 16th 05 04:23 PM
import web table to excel Tom Excel Discussion (Misc queries) 0 February 28th 05 07:51 AM
How do I import data from Microsoft Project 2003 to Excel? RgilbertProjMgr Excel Discussion (Misc queries) 3 December 31st 04 01:07 PM


All times are GMT +1. The time now is 11:24 PM.

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

About Us

"It's about Microsoft Excel"