Columns on 2 Axes

[Dirk]

I know that in MS Excel under Custom types of Charts you
get "Lines on 2 Axes", this is perfect but I want to see
BARS and not lines. Can anybody assist me or tell me what
to do. Yes I know there is the option for "Line Column on
2 Axes", BUT this is not going to work for what we want to
do (Me and My Boss) PLEASE help orr assist. Thanx Dirk

 

[Jon Peltier]

Dirk -

Follow the instructions on this page:

http://www.geocities.com/jonpeltier/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[Debra Dalgleish]

Jon Peltier has instructions for creating a column chart on 2 axes:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html#Col2Axes

 

[dvt]

I know that in MS Excel under Custom types of Charts you
get "Lines on 2 Axes", this is perfect but I want to see
BARS and not lines. Can anybody assist me or tell me what
to do. Yes I know there is the option for "Line Column on
2 Axes", BUT this is not going to work for what we want to
do (Me and My Boss) PLEASE help orr assist. Thanx Dirk

Make the chart as a "Line Column on 2 Axes" type. Select one data series
and from the menu go to Chart | Chart type and select column. Repeat this
action with the other data series.

Dave
dvt at psu dot edu

 

[Andy Pope]

Hi Dirk,

Select one of the lines, Right Click and from the popup menu choose
Chart Type. Pick the bar chart. Repeat for the other series.

I know that in MS Excel under Custom types of Charts you
get "Lines on 2 Axes", this is perfect but I want to see
BARS and not lines. Can anybody assist me or tell me what
to do. Yes I know there is the option for "Line Column on
2 Axes", BUT this is not going to work for what we want to
do (Me and My Boss) PLEASE help orr assist. Thanx Dirk

--

Cheers
Andy

http://www.andypope.info