The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
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