Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically updating cells in other files. | Excel Discussion (Misc queries) | |||
Automatically updating table | Excel Discussion (Misc queries) | |||
Automatically updating | New Users to Excel | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Linked Sheets not updating automatically | New Users to Excel |