Unfortunately, there is no easy way to maintain formatting when
information in a chart is from a cell link. You can adapt the ideas at
http://www.tushar-mehta.com/excel/tips/index.html (scroll down and
click the 'Dynamic textbox in chart with custom formatting' link) to
get to http://www.tushar-mehta.com/excel/ti...namic%20chart%
20textbox.pdf
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi,

I am using a bar chart to show data collected from scientific experiments. I
need to label each bar on the x axis with a seperate value (100uM H2O2, 200uM
H2O2 etc). However, the formatting shown in the cell is not carried through
to the chart - i.e. in H2O2 both 2's should be subscript. I am sure there
must be an obvious way to do this - lots of people must need it for chemistry
(e.g. formulas) and general maths (e.g. cm2).

Any ideas?