Can anyone tell me if there's a way to plot Quarters and Months ( of same Quarters ) figures on the same Chart.

I have  two lovely charts one for quarterly figures and one for monthly figures.
   When I showed the two charts to my boss he wants both on one chart cos that's what the format of industry standard needs to be.
    I thought no problem but oh boy. It seems I can't have two x axis ( one for months and one for quarters ) also you can't Ave or sum one series and have the other with 'none' ie no summing or averaging etc so that option is out. I've looked at a combo chart but it doesn't seem to allow a 'none' and a 'sum'.

  My queries are built for two 'nones' ie no summing, averaging needed on the chart.
   I want to show a wide quarter bar with the individual months inside the wide bars in a different colour.
  Is this even possible without involving export to excel?