Help with Dynamic chart in Excel
Captain Cthulhu
Registered User regular
Registered User regular
I'm trying to define a range of Data that updates dynamically as new cells are populated, automatically updating graphs.
I'm trying to define the parameters of one axis using this formula:
=OFFSET(Sheet1!R3C2,0,0,COUNT(R3C2:R44C2))
But I click OK and it just returns "That function is not valid" but I see that it has selected the correct cells, so I don't see what the problem is. Also, I can add or subtract numbers from that last count and I see it correctly displayed on the data, but still it won't let me actually implement it. I'm new at this so I might be missing some simple crucial step, but that's why I ask here. Thanks!
I'm trying to define the parameters of one axis using this formula:
=OFFSET(Sheet1!R3C2,0,0,COUNT(R3C2:R44C2))
But I click OK and it just returns "That function is not valid" but I see that it has selected the correct cells, so I don't see what the problem is. Also, I can add or subtract numbers from that last count and I see it correctly displayed on the data, but still it won't let me actually implement it. I'm new at this so I might be missing some simple crucial step, but that's why I ask here. Thanks!
Captain Cthulhu on
0