charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

Charts

resolvedResolved · Low Priority · Version 2003

Brian has attended:
Excel Intermediate course

Charts

I use charts that have a axia on ranging from 100,000 to 500,000 how can I change it to say 100k to 500k

RE: Charts

Hi Brian

Thank you for your question and welcome to the forum.

If you double-click on the chart axis showing your values, you will find an option for display units. Try changing this to thousands (or millions) and click OK.

I hope this helps.
Amanda


 

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips


Server loaded in 0.08 secs.