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