Technical formatting in data labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
First, get a real mu by holding ALT while typing 0181 from the numeric
keypad: µ. For subscripts and superscripts, the usual suggestion is to
find a chemical font that has extended characters with such formatting
built into the font. It is possible to format chart and axis titles,
data labels, and text boxes (not axis tick labels) character by
character, so that some characters can be sub/superscripted, a different
font, or a different color. I've written routines to transfer this
formatting from a cell to a chart text element. Unfortunately so far
it's almost one-off; each time it must be pasted in and tweaked until it
works. Some day I'll revise the code so it's more durable.

Essentially how it works is that you first transfer the text of the cell
to the text element, then you sample the formatting of each character in
the cell, and apply this to the corresponding character of the text element.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top