Data labels code for 2 point sizes

Topic

New Reply

I am trying to make the percentages in 14 point and the letters next to them in 12 point in the 2 charts attached. Actually, it’s not just the 2 charts, i’d like to have a macro that could go through several charts and make the percents 14 pt and the letters 12 pt. So in sheet 11a of the attached, the 66% should be 14pt and the “C” next to it should be in 12 pt.

How do i do this in a macro that will work in excel 2003 and 2007 that identifies the percents from letters. Thank you for the help.

Reply | Quote

Replies

Hi jha,

There’s a lot of code in that workbook (~350 lines) and the rather long subs have meaningless names (HowLongCanThisGoOn, WillThisNeverEnd) and few comments as to what the code is meant to be doing. Perhaps you could post a stand-alone sub comprising just that portion of the code you’re having trouble with.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote