Dynamic Excel Chart Help

[davygryan]

I need some help with a dynamic chart or a chart that automatically updates depending on the month. I have a table below that will update automatically at the beginning of a new month. What I would like is for the associated bar chart to update monthly too. The only way I can currently do this is if I select all the data for the year and then it will populate once the new month starts. This however leaves all the other month blank in the chart and I would only like to show months where there is data.

The bar chart will have Complete and Received on the y-axis and the month on the x-axis.

	Month	Complete	Received
Sep'12	9	0	6
Oct'12	10	0	3
Nov'12	11	5	19
Dec'12	12	5	0
Jan'13	1	13	5
Feb'13	2	9	16
Mar'13	3	17	3
Apr'13	4
May'13	5
Jun'13	6
Jul'13	7
Aug'13	8
Sep'13	9
Oct'13	10
Nov'13	11
Dec'13	12

<COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY>
</TBODY>

 

[Akashwani]

Hi,

Take a look here....

Excel Dynamic Chart #10: OFFSET Function Dynamic Range - YouTube

If this doesn't do what you require, Mike has loads of videos on Dynamic ranges and charts.
Or you can take a look here....

http://peltiertech.com/Excel/Charts/Dynamics.html

I hope that helps to point you in the right direction.

Good luck.

Ak

 

[davygryan]

Thanks for the reply AK I will have a look. Much appreciated

 

[Akashwani]

Hi,

I'm sure that you will find your solution at one of the two sites, good luck and thanks for the feedback.

Ak

 

[davygryan]

Hi,

I'm sure that you will find your solution at one of the two sites, good luck and thanks for the feedback.

Ak

Hi AK

I just wanted to give some feedback on the help you gave me. I have now "mastered" these OFFSET charts.
Using this function has greatly enabled me to report up to date metrics and charts and has saved me a lot of time.

Thank you again for the assistance

davygryan

 

[Akashwani]

Hi davygryan,

Thanks for the feedback, I'm pleased that you have found the information helpful.

Ak