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.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,117
Messages
5,857,483
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top