Charting in 2 axises

[Joan Perry]

I need to chart on 2 axises showing the data as two
separate columns next to each other. When I chart the two
columns I lose my second axis on my chart. When I show my
second axis on the chart, then the two columns are laid
on top of each other. I want my second axis to show but I
want the two columns to show as separate next to each
other.

 

[Chris Brennan]

What about changing your chart to a 3d model. 3d models can be panned
to any angle which will enable you to see overlays.

It's too bad there's not an image pasting function here. I have some
graphs that are 3d that might make more sense if seen.

 

[Jon Peltier]

Joan -

You need some blank data to keep the columns to the left or right of center. This
web page explains how:

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

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

 

[Jon Peltier]

For the most part, 3D charts are more difficult to interpret. Joan will have better
results using my suggestion to keep the chart in 2D.

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