Chart shows 4 quarters in 4 years

[Huy Nguyen]

Hello,

I read an article on Barron's street today about Apple and they have a chart that show 4 consecutive quarters in 4 years. I wish to know how to construct this chart. Can someone please help me?

 

[Somendra Misra]

Hi Huy,

Welcome to Chandoo.org Forum,

See the attached file. Is this match your requirement?

Regards,

 

[Huy Nguyen]

Hi Somendra Misra

Thank you so much for your quick response. I did not expect that someone would get back to me this fast.

I think I wasn't clear in my question. If you take a look at the picture I attached, it shows 4 quarters in 1 year and repeat for other 3 years. Yours shows only Q2 of 4 years. Is it possible to show 4 consecutive quarters in 1 year?

 

[Somendra Misra]

@Huy Nguyen

OK....See the attached the axis of year is textbox laid over graph and linked to year cells.

Just advise if any issue.

Regards,

 

[Huy Nguyen]

Hi Somendra Misra,

This is perfect. Thank you very much. I hope this is not too much to ask but I'm wondering if we can narrow the gap between the years as in the picture? In your graph, I understand that it has one column and we trick Excel to make it look like a gap. But I mean the chart in the picture looks more smooth. I'm just curious. If it's impossible to do, I'm happy with your solution. And thanks again.

 

[Somendra Misra]

Hi,

Glad you like it. Will get back to you in some time.

Regards,

 

[Somendra Misra]

@Huy Nguyen

See the attached file. Please note this is not a single graph but four graphs allign on the same axis with some text boxes.



Regards,

 

[Huy Nguyen]

Wow, this looks really neat and natural. It's a great idea to align 4 charts together. I've never thought about this. Thank you very much for your time @Somendra Misra. You rock!!!

 

[Somendra Misra]

Thanks for your kind words and welcome back anytime.

Regards,