How to change empty ranges from a plot series without generating e

L

luizavala

I am writting a macro that updates the range of a set of series in a plot.
The issue is that some of the ranges contain empty cells. When trying to
change the ranges of series with empty values excel returns the error "Unable
to set the Values property of the Series class".

Any ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access to a series, when it is assigned to an empty range 0
VBA access to a series, after it was assigned to an empty range 0
Chart error: plotting series data XY scatter plot 3
How do I eliminate empty cells from plotting on chart 1
Count Column B if Column A is within a multiple specificed ranges 2
syntax to concatenate two named ranges? 2
Automatize chart building 1
How to change series plotting order without changing legend order? 6

Top