Chart Source Data Changes

Hello,
I am working with Excel 2002 and I have data that needs to be applied to my chart. The problem I have is that I have to manually go to each chart, right click > Source Data and add "M" in the the pace of "J" to plot all the data that I need to display on the chart.

Question is, how do I apply this change throughout the rest of the charts? I am looking to avoid having to manually change each individual chart one at a time.

I have included a sample below


Also, what does it mean when I receive a message "No more new fonts may be applied in this workbook" when I am editing the axis pertaining to my question above?


Thanks