Bar/Symbol Chart Possibilities

[#1]

Hey All,

I am trying to create a Milestone/Gantt Chart visualization and I was wondering if anyone knows if the following can be performed using a single chart?

currently I am producing this by overlaying two charts, one for the bar one for the symbols - works well except when you try to scroll, only the top image scrolls disassociating the data.

when I try to put the same info into a line bar chart I get the following:

any ideas would be greatly appreciated

Thanks,

Vince

[#2]

Hi

will you provide the sample data

it may possible with bar offset option in expressions

[jonathandienst]

Can you not do this with combo chart with symbols for expressions > 2 and select the horizontal style?

[marcus_sommer]

Maybe you could use a combi-chart with bars and points (instead of lines). Maybe also this posting is helpful: Recipe for a Gantt chart

- Marcus

[#5]

when wanting to use multiple symbols in a chart, especially when trying to build a milestone chart, a combo chart is the way to go - it will allow differnt symbols for different expressions

[#6]

Here is some sample data:

SwimLane	DurationBar	BarOffSet	Milestone	MilestoneDate
SwimLane 1	650.375	11/3/2009	Milestone1	8/15/2011
SwimLane 1	650.375	11/3/2009	Milestone2	11/3/2009
SwimLane 2	593	7/15/2011	Milestone1	2/27/2013
SwimLane 2	593	7/15/2011	Milestone2	7/15/2011
SwimLane 3	189	8/9/2012	Milestone3	12/8/2011
SwimLane 3	189	8/9/2012	Milestone1	8/22/2013
SwimLane 3	189	8/9/2012	Milestone4	1/31/2013
SwimLane 3	189	8/9/2012	Milestone2	8/9/2012
SwimLane 3	189	8/9/2012	Milestone5	2/14/2013
SwimLane 3	189	8/9/2012	Milestone6	10/4/2012
SwimLane 3	189	8/9/2012	Milestone7	12/20/2012
SwimLane 4	1131.625	12/29/2010	Milestone1	2/3/2014
SwimLane 4	1131.625	12/29/2010	Milestone2	12/29/2010
Swim Lane 5	790.625	4/3/2012	Milestone1	6/3/2014
Swim Lane 5	790.625	4/3/2012	Milestone2	4/3/2012
Swim Lane 5	790.625	4/3/2012	Milestone5	11/2/2012

The SwimLane is the different rows

The Duration Bar is the length of the bar

The BarOffset is where the bar Begins

The Milestone are the different symbols

The MilestoneDate is the placement of the symbols

[#7]

This is what I am trying to do with the second image I pasted.

The thing is the Milestones are variable ~100 different ones, would I need to create an expression for each name?

Currently I have the swimlane name and milestones both as dimensions and milestone date as the expression.

[#8]

Thanks for the link - I looked at it, but I am currently able to have the Gantt part work, it does not go into how to build in milestones as well.

[Anonymous]

hi vincent,

you are going in right direction using bar chart,please classify each milestone/swimline as an expression each

Regards

Neetha

[#10]

So I would need to make an expression for each potential (~100 different milestones) - wouldnt't that kill performance?