Thread: Expand Data Series for Chart in Excel 2007

I have a column chart that is using non-continuous ranges e.g. A1:G2,A4:G4,A7:G7 and A9:G10 etc. I need some code that will extend all the ranges by one column e.g. A1:H2,A4:H4,A7:H7 and A9:H10. This is because the string displaying the range of cells being used in the chart is so huge that it will not display in the data source dialog box and so each series has to be edited individually. I have many files with many of these charts in them and so this can be very tedious to do manually. Hoping someone can help. Thanks.

can you post an example of a chart pre and post expansion