Guage chart

[#1]

Hi,

i need to compare sales of last month and this month in diff guage chart side by side and LYTD and YTD ,last year this month and this year this month sales this is my requirement how to do this.

iam attaching my excel file .could any one help me.

[sunny_talwar]

Have a look at this thread: How can i calculate growth rate?‌while I look at your current data.

HTH

Best,

Sunny

[sunny_talwar]

By compare do you mean to calculate the growth rate from last period to this period?

[#4]