Chart Source Data Changes

**Lostinexcel2002** · 02-25-2009, 02:57 PM

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

**blane245** · 02-25-2009, 05:16 PM

I just wrote a macro yesterday to produce multiple charts because I was tired of doing them by hand. If you are well-versed in VBA, I can send you a copy. It may not work correctly, but it did save me several hours.

**Lostinexcel2002** · 02-25-2009, 05:46 PM

Let me check it out......Thanks Blane 245

Otherwise, if anyone else have a solution and an answer to my question above I would appreciate any feedback

Thanks

**Andy Pope** · 02-26-2009, 09:42 AM

No simple way to update chart references enmass other than with code.

For the fonts see this article
http://peltiertech.com/Excel/Charts/FixFonts.html

**Lostinexcel2002** · 02-26-2009, 02:33 PM

Thanks Andy!

Based on my example posted earlier, do you have any suggestions on a code?

Thanks in advance

PS I cant seem to access the article you posted Thanks