Superscripting A Portion Of Text In Data Label Of A Chart

[Junoon]

Hi,

i am trying to Superscript the a portion of the text in data labels in a chart placed on a worksheet. Right now i have linked each data label to particular cells in the worksheet. But you can unlink the data label text from the cell. I just linked it for testing purpose.

I have attached a sample file with my code in it.

What i am trying to do is Superscript the Letters only and not the numbers. Interestingly, the code does superscript each data label correctly, but once it moves to another datalabel in the same series or other series, it seems to superscript some of the earlier data labels incorrectly - i.e. some numbers also get superscripted along with the letters.

e.g S23FD should become ^S23^FD. But it is very erratic. i may be missing out something here.

What is the cause of such erratic behaviour?

Any help will be most appreciated.


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htJ6TpIOXR
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htOKs4jh3M
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[Excel Fox]

For some reason, this is working flawlessly in Excel 2007, and erroneously in Excel 2010. Can't figure out why!

[Junoon]

Exactly ExcelFox.

even tried using points, but same erratic behaviour in Excel 2010. this is leading to wrong stats results for ppl who are on 2010.

any alternate way to overcome this problem? somewhere on the net, in some post, someone mentioned of using Excel Comments to add superscripted/subscripted text to data labels.

[Excel Fox]

Cross Post? superscript/subscript a portion of data label | Chandoo.org Excel Forums - Become Awesome in Excel

Junoon, please read the cross-posting guideline here, and ensure you follow the same.

http://www.excelfox.com/forum/f25/me...-posters-1172/

[Junoon]

thanks Excelfox.
since didnt get a favorable response, was trying to see if any other forum provides suitable solution. Will abide by rules.

[Excel Fox]

If it's of any help, I'm using Excel 2007 MSO 12.0.4581.1014, and the code that I posted is working absolutely fine.

[Junoon]

Thanks, but i am using 2010 on one laptop and 2013 on another. Doesn't seem to work in them. Only works in 2007 in another computer.