Prev: changing from days to months
Next: Excel 2007 - Printing graphs with no data or graph lines
From: BorisS on 2 Jul 2008 15:27
I have a 2-axis bar/line chart, and the bar values (primary) go from 0 to
18,000, while the secondary goes -4% to 15%. I am having trouble forcing the
axes to both cross at a horizontal 0 (which implies that the primary axis
would have to either start negative and cross at 0 (not preferred, because
logically won't make sense to have a negative number possible for this
access) or have the primary start at 0 and go up, while the secondary starts
at negative (below where the primary is starting to be drawn) and then hits
at zero.

cannot figure out any way to do this. Any help?
--
Boris
From: Jon Peltier on 2 Jul 2008 22:49
This is one of the issues that has led data viz expert Stephen Few to swear
off dual axis charts in "Dual-Scaled Axes in Graphs-Are They Ever the Best
Solution?"
(http://www.perceptualedge.com/articles/visual_business_intelligence/dual-scaled_axes.pdf).

You are better off with two separate charts, one for each of the disparate
data sets. Or you could make a panel chart which shows each data set in its
own panel of a single chart:

http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

If you still insist on saddling a single chart with two incompatible scales,
you could try this technique to coerce the two scales into a precarious
balance:

http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"BorisS" <BorisS(a)discussions.microsoft.com> wrote in message
news:992CF0AE-4E8E-47E0-BB5D-3ED1BDDD9D45(a)microsoft.com...
>I have a 2-axis bar/line chart, and the bar values (primary) go from 0 to
> 18,000, while the secondary goes -4% to 15%. I am having trouble forcing
> the
> axes to both cross at a horizontal 0 (which implies that the primary axis
> would have to either start negative and cross at 0 (not preferred, because
> logically won't make sense to have a negative number possible for this
> access) or have the primary start at 0 and go up, while the secondary
> starts
> at negative (below where the primary is starting to be drawn) and then
> hits
> at zero.
>
> cannot figure out any way to do this. Any help?
> --
> Boris


 | 
Pages: 1
Prev: changing from days to months
Next: Excel 2007 - Printing graphs with no data or graph lines