I have an excel file below set up where reports are genereated using marcos from a list by copying each cell into the cell which allows the chart to be generated,
I need some help as when the graphs are generated even though on the sheet they appear to ignore quaters with no value's as I've set a macro up to hide relevent rows,
When each sheet is saved it will still plot missing quaters on the axis;
use the auto button under 'reporting' tab (scroll down)
Q3 reporting.xlsm
Helping me would save days of work!
Bookmarks