Solved

MS Project export

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Project tasks time minimum 5 38
Using SUMPRODUCT with a Date Range 6 42
Compare Excel spreadsheet question. 2 30
Software to convert png to .ico 17 74
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

734 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