View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Column Chart with 2 axes

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?