ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Subscripted text in the legend of a graph (https://www.excelbanter.com/charts-charting-excel/151136-subscripted-text-legend-graph.html)

[email protected]

Subscripted text in the legend of a graph
 
Hi,
I have been trying to write a legend in a graph which has some of its
part subscripted. However, I have not been able to do so. Could
anybody show me a way out.
nure


Bernard Liengme

Subscripted text in the legend of a graph
 
If your superscripts are just 2 and 3 (squared and cubed) then for toy axis
header use something like y +ALT0179 or y+ALT0179 (digits on the number
pad) to get y² and y³

For other digits you need a fond such as Chemistry font (see
http://www.scs-intl.com/frameload.htm?/chemfont.htm) which has sub and
superscripts for all digits. So does the Calibri font in Office 2007 but
they do not have sequential ASCII values.

See also
http://people.stfx.ca/bliengme/Excel...and_Charts.htm
(needs updating - I refer to the newest XL as Excel 12 /2006 !!!)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
Hi,
I have been trying to write a legend in a graph which has some of its
part subscripted. However, I have not been able to do so. Could
anybody show me a way out.
nure




lcaretto

Subscripted text in the legend of a graph
 
Select the text that you want to subscript

Select Format Axis Title from either the format menu or a right click menu

Check the subscript box in the resulting dialog and click OK

Note that you can use this not only for subscripts, but also for a variety
of changes to individual characters in titles, legends, etc.

" wrote:

Hi,
I have been trying to write a legend in a graph which has some of its
part subscripted. However, I have not been able to do so. Could
anybody show me a way out.
nure



Andy Pope

Subscripted text in the legend of a graph
 
Hi,

Your suggestion will not work for characters within the Legend text.
Formatting is all or nothing for each legend entry.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"lcaretto" wrote in message
...
Select the text that you want to subscript

Select Format Axis Title from either the format menu or a right click menu

Check the subscript box in the resulting dialog and click OK

Note that you can use this not only for subscripts, but also for a variety
of changes to individual characters in titles, legends, etc.

" wrote:

Hi,
I have been trying to write a legend in a graph which has some of its
part subscripted. However, I have not been able to do so. Could
anybody show me a way out.
nure





All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com