Hello,
I have an array of data with labels in column A and B that can e resized by changing a single value... up to 500 entries long. I plotted a bar chart of the whole 500 entry range, just in case I change the magic value to grow the values that show up from 20 to, say, 150. When I 1st make the bar chart, it seems to be smart and just plot the non-blank cell values. That's fine, except when I change the range to light up several more values (they o from "" to a real value), the bar chart doesn't expand.
Can I refresh the chart... or even make it automatic?
Thanks!
I have an array of data with labels in column A and B that can e resized by changing a single value... up to 500 entries long. I plotted a bar chart of the whole 500 entry range, just in case I change the magic value to grow the values that show up from 20 to, say, 150. When I 1st make the bar chart, it seems to be smart and just plot the non-blank cell values. That's fine, except when I change the range to light up several more values (they o from "" to a real value), the bar chart doesn't expand.
Can I refresh the chart... or even make it automatic?
Thanks!