pivot chart question

J

J L C

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.
 
S

ShaneDevenshire

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?
 
S

ShaneDevenshire

Oh and one more thing, in the title you mention pivot chart, but you don't in
the body of the message. Is this chart from a pivot table and if so do you
need to retain the link between the chart and pivot table range?
 
M

mwam423

hi shane, very interested in seeing what you described below. once the site
is back up please post your solution, thanks!


: Hi, You can do this by using two axes - one for
the small series, the other for the large series.
 
J

Jon Peltier

Double click a series, on the Axis tab of the dialog select Secondary.

- Jon
 
J

Jon Peltier

It depends on the chart type you've selected. If you've selected any of the
(unsavory) 3D flavors, you cannot mix chart types or axes. If you stick with
the 2D varieties you have a lot more flexibility.

- Jon
 
A

Andy Pope

Is the OP's problem though that it's a single point in a series that is out
of proportion with the rest. Rather than two series with different value
spreads.

Cheers
Andy
 
J

Jon Peltier

I didn't consider that. Shane mentioned two series, and I assumed that's
what the OP wanted. That's not necessarily true.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top