# Complex Combination Charts

#### greeman

##### New Member
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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Any New Eyes ...

... have any suggestions, I'm stumped

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

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

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

Any new Input

I'm still stumped

Replies
0
Views
514
Replies
4
Views
656
Replies
1
Views
368
Replies
4
Views
527
Replies
0
Views
600

1,212,096
Messages
6,105,940
Members
447,985
Latest member
gigi11

### 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.

### Which adblocker are you using?

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

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