search

PopovGP / Export-MS-Project-to-MS-Excel

Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
GNU General Public License v3.0
32 stars 10 forks source link

Option to change gantt view from weekly to monthly or quarterly etc #7

Closed rcowen1977 closed 2 months ago

rcowen1977 commented 2 years ago

It would be excellent if the user could select the period for the gnatt view from being weekly to Monthly, quarterly etc.

PopovGP commented 2 years ago

It would be excellent if the user could select the period for the gnatt view from being weekly to Monthly, quarterly etc.

Do you need this feature? Can you give sample project file?

rcowen1977 commented 2 years ago

It would be good to have. I create a Programme plan by linking a number of subprojects together. We have to provide a Plan on a page but when we are not baseline this can change on a regular basis. it would fantastic to see the programme by month. It would save me hours of work each month. I can provide a set of plans so you can see the type of thing I'm talking about if needed.

PopovGP commented 2 years ago

It would be good to have. I create a Programme plan by linking a number of subprojects together. We have to provide a Plan on a page but when we are not baseline this can change on a regular basis. it would fantastic to see the programme by month. It would save me hours of work each month. I can provide a set of plans so you can see the type of thing I'm talking about if needed.

Yes, please, give some plans to understand the result.

rcowen1977 commented 2 years ago

examplePlans.zip POAP

The bottom section of the image is what I am trying to achieve with the Gantt by month

PopovGP commented 2 years ago

Got it, thanks!

rcowen1977 commented 2 years ago

is this amendment possible?

reza2511 commented 1 year ago

Hi @PopovGP

Have you had any luck finding a solution?

Kind regards

rcowen1977 commented 1 year ago

Hi, Sadly not.

R

PopovGP commented 1 year ago

Hi, Sadly not.

R

Hello! Is it still needed?

reza2511 commented 1 year ago

Hi, Sadly not. R

Hello! Is it still needed?

We really desperately need it. Any help would be greatly appreciated.

Kind regards

rcowen1977 commented 1 year ago

Hi, Yes it's still needed.

reza2511 commented 1 year ago

This is just an example of Monthly Timescale GanttChart

image

PopovGP commented 1 year ago

Ok, I will do it.

PopovGP commented 1 year ago

Hi everyone! Added precedure to export Gantt chart in months, please give a try

reza2511 commented 1 year ago

@PopovGP I appreciate all the help you've provided. Your hard work and dedication have been invaluable. Thank you so much and I wish all the best.

SAMPLE:

MONTHLY:

image

DAILY:

image

NargesNAAM commented 1 year ago

Thanks, you answered all my questions about the Gantt chart.