Solved

MS Project export

Posted on 2014-02-08
1
677 Views
Last Modified: 2014-02-25
I have MS Project 2013 and I'd like to know if it is possible to keep the same format of my Gantt chart when export to Excel. Basically, I have the task names with summary task names and I'd like to keep in that way when exporting to Excel. But it did not work for me. All I got was a list of all the tasks and it is hard to read. Thanks
0
Comment
Question by:leblanc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39849756
This is standard behaviour and I'm not aware of any way to change it - I did have a play about creating new maps and so on but the intention seems to be that you use the 'outline level' column to reformat. level 1 is summary tasks, 2 the level below etc

Once you have the export you can use Conditional Formatting to change the text of summary items to Bold, first level items to (for example) a smaller font and third level items to italics  based upon the outline level and so on.

Alternatively you can use autofilter on the outline level and manually apply a cell style to the tasks that are filtered in this way. This has the advantage of allowing a change to the Alignment - ie: you can add a left indent - which is not available in conditional formatting - in the attachment: filter on level 2, select all tasks names and choose 'style 1' from the cell styles drop down

A third option is to put the data into a pivot table and use the various formats in there to achieve what you want - however the most useful view for that seems to have been deprecated in 2013 so its not as flexible as it was
test.xls
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question