Complex Combination Charts

[greeman]

I am try to create a complex combination chart based on data generated from multiple pivot tables. My preference is to create these in excel but if other software would be better suited please advise.

Basically I have 10 data series over 2 Y axis. 5 of the series are simple line charts no problems. However of the first 5 series I would like the following

Series 1 - Bar (No fill)
Series 2 - Bar fill colour overlapped to sit below series one
Series 3 and 4 - Stacked Bar
Series 5 Bar

Effectively it looks a three bar chart.

The only why I have been able to do it to date is to have two charts one over top of the other, with the top one transparent, but doesn't seem all that logical (or easy).

Any guidance greatly appreciated.

 

[greeman]

Any New Eyes ...

... have any suggestions, I'm stumped

 

[PaddyD]

can you give us a little more detail about the data you're plotting in each series.

 

[greeman]

Here Is The Data set is csv

NZD/EUR,200504,200505,200506,200507,200508,200509,200510,200511,200512,200601,200602,200603
Budget,1200000,600000,490000,920000,360000,790000,870000,1580000,990000,670000,980000,1130000
Deliveries,630000,1520000,1250000,790000,550000,580000,890000,#N/A,#N/A,#N/A,#N/A,#N/A
Forwards In Place,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,1590000,1610000,1640000,500000,500000
Commitments,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,2280000,830000,1700000,590000,320000
Forecasts,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,0,80000,160000,550000,260000
Budget Rate,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250,0.5250
Market Rate,0.5559,0.5663,0.5820,0.5659,0.5656,0.5709,0.5798,#N/A,#N/A,#N/A,#N/A,#N/A
Delivery Rate,0.5582,0.5582,0.5768,0.5628,0.5614,0.5679,0.5850,#N/A,#N/A,#N/A,#N/A,#N/A
Forward Rate,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,0.5594,0.5588,0.5655,0.5712,0.574
Market Forward Rate,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,0.5843,0.5815,0.5791,0.5768

 

[greeman]

Desired Chart

Y1 Axis: Budget, Deliveries, Commitments, Forecasts, Forwards in Place.
Y2 Axis: All "Rate" Series

Y2 Axis Rate series to be presented as Line charts (Done)
Y1 Axis is the problem; I want it to look like 3 bar charts side by side as follows:

DS1: Budget : Bar with no Fill
Deliveries: Bar filled sitting 100% behind Budget

DS2: Commitments and Forecasts: Stacked Bar

DS3: Forwards in Place: Normal Bar

So your usual Bar & Line Combination chart won't do. I actually want a Bar/StackedBar & Line Combination

 

[greeman]

Any new Input

I'm still stumped