Automatically updating Graphs
 

Just wondering if I could automatically change a graph.

For example I do a number of graphs for every month, obviously days of the
months changes so on a month where there are 31st, there isnt a problem. The
problem is when i have a month which only has 30 or 28 days. This leaves the
last 3, 2 columns zero but are still on the chart but are shown as zero.

Does anyone know how to automatically adjust the source data? perhaps with
an if statement?

Thanks

a simple way to do it is to simply hide the cells when the month doesn't have
31 days.

"Rich Gibbons" wrote:

Just wondering if I could automatically change a graph.

For example I do a number of graphs for every month, obviously days of the
months changes so on a month where there are 31st, there isnt a problem. The
problem is when i have a month which only has 30 or 28 days. This leaves the
last 3, 2 columns zero but are still on the chart but are shown as zero.

Does anyone know how to automatically adjust the source data? perhaps with
an if statement?

Thanks

This search string in Google provides several replies to nearly identical
questions

chart dynamic range group:*excel*


"Rich Gibbons" wrote:

Just wondering if I could automatically change a graph.

For example I do a number of graphs for every month, obviously days of the
months changes so on a month where there are 31st, there isnt a problem. The
problem is when i have a month which only has 30 or 28 days. This leaves the
last 3, 2 columns zero but are still on the chart but are shown as zero.

Does anyone know how to automatically adjust the source data? perhaps with
an if statement?

Thanks