How to amend the Y axis to just show the top and bottom of the range?

**The_Snook** · 08-21-2012, 09:48 AM

Hi,

I've got a chart that simply shows sales and commission. It's a chart with a primary and secondary axis and i'd like both axes to just show the bottom and the top of the range, i.e. 0 for the bottom and £1bn for the top on the sales (primary) axis and £1m for the top on the commission (secondary) axis. At the moment i've resized the chart quite small but it's still showing a number in the middle (the midpoint number) on both axes. Is there any way I can make it disappear?

Thanks,

Snook

---------- Post added at 02:48 PM ---------- Previous post was at 02:43 PM ----------

It's probably not best practice but i've just achieved what i'm looking for by placing a shape (square - white fill and line) over the numbers in question.

I'd still like to know any alternative approaches if people know of any?

Regards,

Snook

**Andy Pope** · 08-21-2012, 09:48 AM

Make the Major unit the same as the max

**The_Snook** · 08-21-2012, 09:51 AM

You are the man, cheers Andy!

**Cutter** · 08-21-2012, 07:46 PM

@ The_Snook

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.