We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

excel - unable to change 'display units' box as greyed out

help....

i have created a graph in excel, but want the horizontal axis to use larger numbers,

when i go into the format menu, and try to change the 'display units' (currently set to none) it is greyed out

any ideas on how i can un-grey it?
smile --- it makes people wonder what you are up to.... ;) :cool:

Comments

  • If you click on the edge of the graph rather than the centre they shouldn't be greyed out.
    2026 Mortgage-Free Wannabes #24 £8797.50/£20000 OP
  • robnye
    robnye Posts: 5,411 Forumite
    Part of the Furniture Combo Breaker
    tried that and all sorts of others.

    i think it it because it is a 2d bar graph it doesnt like it all other types are ok.
    smile --- it makes people wonder what you are up to.... ;) :cool:
  • isofa
    isofa Posts: 6,091 Forumite
    Double click one of the values on the axis you want to change, it'll bring up a "Format Axis" dialog with the tools you need...
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.7K Banking & Borrowing
  • 254.2K Reduce Debt & Boost Income
  • 455.1K Spending & Discounts
  • 246.8K Work, Benefits & Business
  • 603.3K Mortgages, Homes & Bills
  • 178.2K Life & Family
  • 260.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.