Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Project export

Posted on 2014-02-08
1
Medium Priority
?
712 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 2000 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

718 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