Chart Data Range

  • I need to read data for a group of charts into a master template file.

    Sometimes my chart data range needs to be
    Other times, when different data is read in, the same chart may need to only read

    Is there any to name a range to read until row AT reaches it's first blank?


  • Re: Chart Data Range

    Depending on how you are selecting the range there is an IsEmpty(ActiveCell) that I use when running a loop to check cell contents to be included in specific ranges. If you used something like:

    Which can probably be trimmed down even more depending on your situation.

  • Re: Chart Data Range


    A non-macro solution would be to create a dynamic range name for the chart data. That way when you specify what range the chart uses, you put in the range name you created and the chart will automatically adjust from then on.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!