I have a database with updating column's of dates (A) and corresponding numbers (B). I want to make a chart thats data range is B1:B6000, but have the chart only show rows which are greater or less than "0". (I.E. up to the current date). How can I do this?
HI,Originally Posted by cwik
one way is to hide the following rows and set the 'Visible Cells Only' option (Tools, Options, Charts)
depending how your data is gathered for Column B then a Worksheet_Change or Worksheet_Calculate event could unhide the next (say) 5 rows etc.
hth
---
Si fractum non sit, noli id reficere.
Well, hiding cells won't really work, as I want the chart to be constantly updating as I add new data. The problem is when I put in all the cells from whole column, I get a line graph of all my entries in the first 1/10th of the chart, and then just a straight line for the rest of the graph (most of it).
what I want it to show is a 'to date' section of the database. This range will be constantly changing.
so you didn't test to see that it does exactly that.another way is to use some VB code to update the Source Data (and other) settings to match the number of entered items.The problem is when I put in all the cells from whole column, I get a line graph of all my entries in the first 1/10th of the chart, and then just a straight line for the rest of the graph (most of it).
what I want it to show is a 'to date' section of the database. This range will be constantly changing.
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks