A
ajames
I have created my rolling graph using the helpful reference that was
previously given to me
(http://peltiertech.com/Excel/Charts/DynamicLast12.html). However, I can't
get the Named Range 'chtCats' to work as I do not want the user to have to
add a new month each time they have new data, e.g. I want to have Feb 06, Mar
06 etc already displayed in the spreadsheet. This causes the named range not
to work as it does not recognise these cells as blank anymore.
I have tried adding an IF statement that returns "" if the data cells are
empty, i.e. as soon as the user inputs some data against that month, the
month will automatically display, but the COUNTA function does not recognise
"" as blank - please help!
previously given to me
(http://peltiertech.com/Excel/Charts/DynamicLast12.html). However, I can't
get the Named Range 'chtCats' to work as I do not want the user to have to
add a new month each time they have new data, e.g. I want to have Feb 06, Mar
06 etc already displayed in the spreadsheet. This causes the named range not
to work as it does not recognise these cells as blank anymore.
I have tried adding an IF statement that returns "" if the data cells are
empty, i.e. as soon as the user inputs some data against that month, the
month will automatically display, but the COUNTA function does not recognise
"" as blank - please help!