How to change Excel charts series at one go?

**Eurobeater** · 07-20-2018, 03:40 AM

I have an issue with the data table and charts as in the screenshot below.

Excel.png

Basically, each chart has it's data series based on the first two tables on the left. For ex, in the first chart on the right. The first series' data range is from C2:C11, the second data series is from D2 to D11. The x axis is based on the array A2 to B11. There is also a third dataset based on F2 to F11.

What I would want to do is to create more charts down the sheet but the data range is to be moved down the table by 2 smaller tables. Basically, the second table should be based on the C and D parts of the table, while the 3rd should be based on the E and F parts. But as of now, all of the charts to the right is based on the A and B data only. I would like to change the data series of all the charts as mentioned above quickly as I can have well over 100 charts to plot. Can it be done with VBA? If so what code?

Thanks in advance

**kersplash** · 07-20-2018, 03:43 AM

Can you attach a sample workbook showing what you expect as your result.

Go Advanced -> Manage Attachments -> Upload

**AliGW** · 07-20-2018, 03:47 AM

As Kersplash says, a sample workbook would help, however I expect the solution will require VBA. Once we determine this, I may need to move your thread. Once we've seen the file, we can make that decision.