Posted to microsoft.public.excel.charting
|
|
Column Chart with 2 axes
Shane -
You definitely have the "prior art" covered. Thanks for the links.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax
http://PeltierTech.com/
_______
"ShaneDevenshire" wrote in
message ...
Hi Jon,
Sorry we missed you at the Summit!
Listed below in reverse chronological order. I don't know if there are
any
links to these:
1. Excel Expert Solutions, Que, 1996, Designing a Dual-Axis Column Chart,
pgs. 718-721.
2. Macworld February 1995, Quick Tips, Impossible column Chart
3. PC Magazine January 1995, page 272, Spreadsheets: Excel Charts with two
Y-Axes.
4. Bank of America - PC Computing tips for the Mac, November 1986, page 4.
--
Thanks,
Shane Devenshire
"Jon Peltier" wrote:
Shane -
I developed the same technique independently, without ever seeing your
prior
references. If any of them are linkable, I'll be glad to include a link
in
the tutorial.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"ShaneDevenshire" wrote in
message ...
Hi Bernard,
How was your trip home? By the way does Jon's website credit me? I
published this in the early 90's in a number of computer magazines.
--
Thanks,
Shane Devenshire
"Bernard Liengme" wrote:
Yes, Jon Peltier knows. He tell all at
http://peltiertech.com/index.html
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Greenfield" wrote in message
...
I have a column chart with 2 bars in each catagory (total 12 bars, 6
categories). I want to put each data series on a separate axis.
When
I
choose the second data series, than format data series, than axis
and
click
on second axis, the chart goes from a column chart to a stack bar
chart.
Does anyone know how to keep the chart as a two column chart on
separate
axes?
|