Thread: Exceed Scale
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default Exceed Scale

Hi Don,
I am happy to say that I don't think that your suggestion will work because
if you just adjust the maximum scale (which sorts my scale problem) it cuts
off the bar so that it goes to the max of the scale but no further.
--
Any other suggestions or am I missing something?
MarkN


"Don Guillett" wrote:

Can't you just adjust the max scale at lower than the "off the chart" number

--
Don Guillett
SalesAid Software

"MarkN" wrote in message
...
Hello,

I have been asked to produce a simple column chart where one particular
column goes "off the scale", the idea being that this particular product
is
so good compared to other similar products that it is "off the chart".

I have produced the chart and obtained the required result by covering the
scale that I don't want to show with a drawn white rectangle with no
borders.

As always happens with workarounds, I am wondering if there is a less
dodgy
solution to my problem.
--
Any suggestions welcome,
MarkN