You always can make a separate table for chart - on same worksheet where chart is situated, or another sheet. You get all data needed for chart there (Only needed data!). Chart will be based on this table, not on table meant for users. You can leave this table visible, or hide it from users (when on separate sheet, then you can hide sheet, when on same sheet with chart, then you can hide columns/rows with table).

Thanks, That should work.

Please mark the thread solved if this answer is what you need

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post