Hi,

You can do this by using two axes - one for the small series, the other for
the large series. I invented a way to do this about 15 years ago for column
charts but the same technique works for bars.

Before I write out the steps - what version of Excel are you using <=2003 or
2007? And are these bars or columns?

--
Thanks,
Shane Devenshire


"J L C" wrote:

Okay, I'm sure I'm not using the correct language while asking this question,
so bare with me....
I have a bar chart plotting volume numbers for each package we sell.
However, only ONE product sells over 1000 cases a week and the rest of the
products are like 10 to 40. So, my chart has one long bar for one product
and small ones which you can hardly see. Is there anyway to build a chart
that doesn't skew out so much. Thanks for the assistance.