In a pivot chart, the best bet is to plot the pairs on primary and secondary
axes. Double click one of the small-valued series, and on the Axis tab,
select Secondary. Select the other small-valued series and click F4 to
repeat.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Neil" wrote in message
...
Hello
I have a Pivot table with 4 different kinds of data on. Two sets of the
data
are in the 500-900 range and the other two are 5-10 range and 30-50 range.
I
have these set as a line chart so i can can compare the data over
differnet
weeks. But with this weighting it makes the lower value ranges harder to
see
clearly. Is there a way i can change the Y Axis to ditch say 200-400 and
bring tham closer together.
I Hope this makes sense
Thanks