Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Canton, Ohio, USA
    Thanked 0 Times in 0 Posts

    'Floating' Graph Label (Excel XP)

    I have several graphs that I update each month in EXCEL. These graphs are the budget to actual variance displayed in bar graphs. Consequently, "0" [zero] is where actual equals budget, a positive bar is actual exceeds budget and a negative bar is where actual is below budget. On the each graph, I have added a text block "budget" and placed this text block over the zero on both the right and left graph axis. But each month, I have to review each graph individually as EXCEL adjusts the axis to account for increased variances between budget and actual...I then must manually move my text blocks to the new location of the zero line each month. Is there a way I can tell EXCEL to use the word "budget" where it would normally display the zero but still keep the numeric positive and negative axis numbers? If so, I can I correctly assume that this text would also realign automatically when EXCEL re-calibrates the axis to account for increased variances?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Burwash, East Sussex, United Kingdom
    Thanked 229 Times in 210 Posts

    Re: 'Floating' Graph Label (Excel XP)

    Hi Jim,
    If you right-click on the axis, choose Format axis, then on the number tab, change the format to custom and enter something like 0;-0;"Budget";@ as the code - this should display Budget instead of zero. Depending on your values, you may need to pad the positive and negative formats so that Budget displays on one line - e.g. _?????0;_????-0;"Budget";@
    Hope that helps.

    Microsoft MVP - Excel

Posting Permissions

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