Complex Combination Charts

greeman

New Member
Joined
Jul 31, 2005
Messages
38
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.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
can you give us a little more detail about the data you're plotting in each series.
 

greeman

New Member
Joined
Jul 31, 2005
Messages
38
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

New Member
Joined
Jul 31, 2005
Messages
38
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top