Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I apply footnote indicators to either Y axis labels or the legend in Excel 2002 they don't get superscripted. Currently I have to request that the typesetters fix this before we go to print.

    Also, Excel 2002 doesn't 'right justify' the Y axis labels when it wraps them. Again I have to request a fix from the typesetters.

    Are there any ways around these problems?

    Any help appreciated!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You did select the footnote number and change its font characteristic to superscript?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by pieterse View Post
    You did select the footnote number and change its font characteristic to superscript?
    Yes, it just doesn't translate as superscript in the actual graph/chart.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Maybe changing to a different printerdriver helps? Mine behaves as expected.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Unfortunately it shows as standard font within the legend or on the axis of the graph or chart even though it's superscripted in the feeder table. Using a different printerdriver doesn't change anything in this case.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What about using a different font type?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by pieterse View Post
    What about using a different font type?
    We are limited to a specific font for our publication and anyway, how would changing font effect the way Excel transfers a superscripted number to a normal one?

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have no idea, just groping in the dark...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    With respect, I can do that myself and already have. I need sensible, constructive suggestions.

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How are you applying the superscripting to the labels and legends? AFAIK no formatting is allowed to the individual characters, only overall

    If you are applying the formatting to worksheet cells and then having the chart read the cells and add them, it is NOT a FONT issue but a formatting issue. There are some superscript characters (NOT formatting) in the normal fonts but htis is limited to only a superscript 0,1,2, or 3 which serve the purpose of using "sqr" and "cubic" units (ft² and ft³) but do not help if you need all 10 numbers for footnotes.

    The only thing I can suggest since you want particular fonts is to create your own (or buy one) font driver which is the font you need and has all 10 superscripted characters (you may even want the 10 subscribted ones as well) as part of the font and not to rely on formatting. I think this may be more practical than asking MS to add formatting capability to the chart options.

    Steve


  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Steve is right, I misread your original question. You can only change character formatting in the cart title and in the axis titles, not for elements the chart derives from worksheet cells.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •