M
matthoffman33
Hi,
I have a column of values that I retrieve from a database based o
dates. It will always try to retrieve an entire week (Sun - Sat) at
time. This is done for charting purposes. My problem is that if it'
only Wednesday, the chart will show 0's for thurs, fri, and sat b/c th
DGET function can't find the values for those days (because they haven'
been calculated yet). So, I either need to have the DGET functio
return those days as null values, or have the chart not graph the cell
that have #VALUE! in them. Any ideas???
Thanks for the help,
Mat
I have a column of values that I retrieve from a database based o
dates. It will always try to retrieve an entire week (Sun - Sat) at
time. This is done for charting purposes. My problem is that if it'
only Wednesday, the chart will show 0's for thurs, fri, and sat b/c th
DGET function can't find the values for those days (because they haven'
been calculated yet). So, I either need to have the DGET functio
return those days as null values, or have the chart not graph the cell
that have #VALUE! in them. Any ideas???
Thanks for the help,
Mat