Gantt visualisation challenge
- Thread starter torben
- Start date
Just some very basic lines attached here. And yes, the dates will span over years, but could be monitored in periods of choice. I illustrated it with a quarterly review.
Round markers are milestones approved, declined, or in progress. I am not yet sure of the need for formatting the lines, but it would be nice to have the option.
Round markers are milestones approved, declined, or in progress. I am not yet sure of the need for formatting the lines, but it would be nice to have the option.
torben - The data sheet should now reflect the gannt.
Did You mean Your data sheet's data or what?
Hint: It would be better to keep those dates NOW in the same sheet, that You could notice ... something!
Four gate's dates would see by 'line' (... and dates ... really means dates!).
Your 'data' has also two kind of GN statues with text
... I didn't start to guess ... four gates.
Hope ... hmm ... I miss that sentence. I missed term 'focus'.
Did You mean Your data sheet's data or what?
Hint: It would be better to keep those dates NOW in the same sheet, that You could notice ... something!
Four gate's dates would see by 'line' (... and dates ... really means dates!).
Your 'data' has also two kind of GN statues with text
... I didn't start to guess ... four gates.
Hope ... hmm ... I miss that sentence. I missed term 'focus'.
torben
#2 Reply - I asked 'Do You have data for that Gannt-chart?'
#5 Reply - You sent 'data' which did not reflect Your illustrated.
Did You check my previous file?
There are some similarity with Your illustrated ... or how?
There are also some notes/hints.
... and now You ask: what data is needed? ... hmm?
You would get correct data somewhere.
Many things depends of that data!
After that,
it's possible to figure how to get illustrated output from it
... or as close output as possible.
Someone have to have clear image/vision to give with needed data.
#2 Reply - I asked 'Do You have data for that Gannt-chart?'
#5 Reply - You sent 'data' which did not reflect Your illustrated.
Did You check my previous file?
There are some similarity with Your illustrated ... or how?
There are also some notes/hints.
... and now You ask: what data is needed? ... hmm?
You would get correct data somewhere.
Many things depends of that data!
After that,
it's possible to figure how to get illustrated output from it
... or as close output as possible.
Someone have to have clear image/vision to give with needed data.
There are no problems ... only challenges,
and those would be because, if You cannot figure logic.
You have to t-h-i-n-k and s-t-u-d-y, how do those would work
... not 'just write something somewhere'.
> You can edit & add those.
> Editing series would be quicker.
> Adding series ... hmm ... would need more than one second.
I have tried to ask realistic data ... but no!
Then I gotta do 'my data'.
To that active cell, You should write date eg 17/04/2018!
and those would be because, if You cannot figure logic.
You have to t-h-i-n-k and s-t-u-d-y, how do those would work
... not 'just write something somewhere'.
> You can edit & add those.
> Editing series would be quicker.
> Adding series ... hmm ... would need more than one second.
I have tried to ask realistic data ... but no!
Then I gotta do 'my data'.
To that active cell, You should write date eg 17/04/2018!
Peter Bartholomew
Well-Known Member
@torben You might like to have a look at Craig Hatmaker's site for ideas
https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts
Craig is of the mindset to contribute to the community so would be supportive. Quite a while ago, I set out by placing shapes representing activities within a chart as the parent object. This allowed me to exploit the time axis and had greater potential for interactivity since Charts support mouse move event handling. Without downloading one of Craig's workbooks, I am not sure what he went with finally.
Even examining the code would provide something of an eye opener in any case.
https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts
Craig is of the mindset to contribute to the community so would be supportive. Quite a while ago, I set out by placing shapes representing activities within a chart as the parent object. This allowed me to exploit the time axis and had greater potential for interactivity since Charts support mouse move event handling. Without downloading one of Craig's workbooks, I am not sure what he went with finally.
Even examining the code would provide something of an eye opener in any case.