• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bar chart / Gantt (Possibly)

Rob Mulhern

New Member
Hi All,

Hope you are well? Sorry it's one of these emails again but I am very stuck.

Help please! Hopefully you have done this before as I am struggling with the online help.

I need to add data to a bar chart format that shows, by "Project Name" the period between start and end date.

Also needs to show the £Value of the bar - Column G - "5 Year Cost" (All chart elements from the table are highlighted in yellow in the table).

Each bar will need to start and finish at different periods. I't not a project as such so % complete etc is not needed just the Anticipated time-frame + £Value as a label rather than a measure / value.
So Column H - "Anticipated Start Date" to Column I "Anticipated End Date".

Importantly the Bar should be coloured as per the "BRAG" Status (Column C) also.
Hope that can be automated in the chart rather than manually in case of any updates to the "BRAG Status" (colour Legend in Column M2) in the data set?

Please see the attached data set and what I then visualise (ref A:26 to A:51) the chart (actual chart needs to be built on a second ws) for it to look like.

Just need to show monthly and yearly so Jan-18 to Feb-19 per project.

I have found some help but can't seem to get it working with this dataset the way I need it to.

Thanks very much
 

Attachments

  • Chandoo Help Project Pipeline.xlsx
    14.7 KB · Views: 7
Rob Mulhern
This could belong to Discuss Data Visualizations and Charting
and
with VBA it should be done.
Here one manual sample version.
 

Attachments

  • Chandoo Help Project Pipeline.xlsx
    21.9 KB · Views: 10
Back
Top