Microsoft Project

[smiksa]

I have an excel chart which I would like to input into project. How do I
know if excel is a better application to use over project for what I am doing?

 

[JulieS]

Hello smiksa,

Project does not have the capability to chart data in the manner that
excel does. MS Project is a project managment scheduling tool. I am at
a loss to say how you would "input" an excel chart into project.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[John]

I have an excel chart which I would like to input into project. How do I
know if excel is a better application to use over project for what I am doing?

smiksa,
Well if it is a chart, Excel is by far the better application.

Now, if you told us what you are doing (i.e. your end goal), then maybe
we could give you advice on whether Project can help.

John
Project MVP

 

[smiksa]

Thanks John. What I have currently is a chart with information such as who
the customer is, the order #, a customer code, the region/description of the
work being done and the start/finish date of the work/project. Currently the
chart shows all the different projects being done throughout the US and the
status of the project thereof. I was having difficulty inputting such
information as order #, customer code, region which in the excel chart has
it's own column. Does Project not have the same cability? My boss wanted to
start using Project for this to be updated weekly.

 

[Jan De Messemaeker]

Hi,

Forgive me to bump in, but I have the impression that both Julie and John
interpreted the word "Chart" as a Graph in Excel, not as a "Table" or a
"sheet" or however you call a two-dimensional arrangement of data.
I hope this sheds some light on this discussion.

And yes, in Project you can input things like this, but then you will not be
using 0,1% of its capability.
Project's stronghold is calculating planned data from input such as
relations between tasks, external constraints, resources assigned and
resource availability.

It's a bit like asking whether you can input the addresses of staff in a
Salary application..

Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[smiksa]

Yes, this is more of what I meant. The problem I was having was when I tried
to insert a new column and label it as "Region" for example I then tried to
input data into that column and the data would also go into the "task"
column. Am I doing something wrong or is keeping this data in excel better?

 

[davegb]

Yes, this is more of what I meant. The problem I was having was when I tried
to insert a new column and label it as "Region" for example I then tried to
input data into that column and the data would also go into the "task"
column. Am I doing something wrong or is keeping this data in excel better?

Hi,

Forgive me to bump in, but I have the impression that both Julie and John
interpreted the word "Chart" as a Graph in Excel, not as a "Table" or a
"sheet" or however you call a two-dimensional arrangement of data.
I hope this sheds some light on this discussion.

And yes, in Project you can input things like this, but then you will not be
using 0,1% of its capability.
Project's stronghold is calculating planned data from input such as
relations between tasks, external constraints, resources assigned and
resource availability.

It's a bit like asking whether you can input the addresses of staff in a
Salary application..

Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Thanks John. What I have currently is a chart with information such as
who
the customer is, the order #, a customer code, the region/description of
the
work being done and the start/finish date of the work/project. Currently
the
chart shows all the different projects being done throughout the US and
the
status of the project thereof. I was having difficulty inputting such
information as order #, customer code, region which in the excel chart has
it's own column. Does Project not have the same cability? My boss wanted
to
start using Project for this to be updated weekly.
:


- Show quoted text -

XL, or a database, would be MUCH better for this application. Project
does Critical Path Scheduling for scheduling projects.