OdiN
08-22-2007, 08:45 AM
Okay so I have a spreadhseet with some charts. They point to some ranges on other sheets. These ranges are queries to an Access database. There are 13 weeks worth of data, and only 13 weeks. The queries are setup so they only return the last 13 weeks worth of data.
Now, this is a shared workbook so that people can enter comments on their particular graphs. It is protected, and the sheets with the queries set to Very Hidden.
The problem is that the graphs change themselves.
Instead of staying with that 13 data point range, they change. Some are at 15, some 17. So it throws off how the graphs look. How does this happen and how can I prevent it from happening? If I set the data to refer to 13 cells then how can it just change itself to 15 or 17 cells? This is very frustrating. Is there something else to hard-set the data source? I don't understand how when I tell it what the data source is, that it can increase the range of that data source by itself.
Now, this is a shared workbook so that people can enter comments on their particular graphs. It is protected, and the sheets with the queries set to Very Hidden.
The problem is that the graphs change themselves.
Instead of staying with that 13 data point range, they change. Some are at 15, some 17. So it throws off how the graphs look. How does this happen and how can I prevent it from happening? If I set the data to refer to 13 cells then how can it just change itself to 15 or 17 cells? This is very frustrating. Is there something else to hard-set the data source? I don't understand how when I tell it what the data source is, that it can increase the range of that data source by itself.