Solved

MS Project export

Posted on 2014-02-08
1
660 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now